Reblogged of an interesting summary of querying json in SQL Azure Querying Json Recursively in Azure SQL Database.
SQL Server
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.