[!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)] A [!INCLUDE[tsql](../../includes/tsql-md ...

Occasionally, I need to store hierarchical data in a database. Most common task I've been dealing with is forum posts, where users can make a new post or respond to an existing one or somebody else's ...