CTE and Hierarchical XML Result

(Davide Mauri) Finally i’ve managed to have a hierarchical xml result from a CTE Query. I’ve discovered that SQL Server 2005 cannot do this natively, so at the end i’ve create a .NET Stored Procedure that takes the XML as it cames out from the CTE and produces a hierarchical one.

Read More - Register for Free Membership