Send the following on WhatsApp
Continue to ChatSQL Server Hierarchical Query using the hierarchyid Type - CodeProject https://larsfosdal.blog/2019/04/29/sql-server-hierarchical-query-using-the-hierarchyid-type-codeproject/
SQL Server Hierarchical Query using the hierarchyid Type - CodeProject https://larsfosdal.blog/2019/04/29/sql-server-hierarchical-query-using-the-hierarchyid-type-codeproject/