Querying Json Recursively in Azure SQL Database

Reblogged of an interesting summary of querying json in SQL Azure Querying Json Recursively in Azure SQL Database.

SQL queries to manage hierarchical or parent-child relational rows in SQL Server

All is said: SQL queries to manage hierarchical or parent-child relational rows in SQL Server – CodeProject. Or how to manage parent-child relationship in a single table.