CTE and Hierarchical XML Result

Sun Feb 6, 2005 by Davide Mauri

I've found a trick to solve the problem of creating a hierarchical XML from a CTE query (exposed in this blog entry).

Since it's quite long i've posted it in this article:

Have a nice read!