http://sqlblog.com/blogs/peter_debetta/archive/2010/02/17/converting-hierarchyid-to-xml-in-t-sql.aspxNow that I've discussed converting XML into a set of HIERARCHYID values I thought I'd try to reverse the process... Not sure if you’ve attempted to convert a table with HIERARCHYID to an XML representation, and if you have, I’m sure you’ve experiencedenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/peter_debetta/archive/2010/02/17/converting-hierarchyid-to-xml-in-t-sql.aspx#22412Thu, 18 Feb 2010 03:54:46 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:22412Peter W. DeBetta<p>Well I finally got around to testing with a larger set of data (9000 rows) and the inserts into the XML get logarithmically slower as you process through the cursor. </p> <p>For about 1000 rows or less, it works fine. For up to 2000 rows, much slower, and after that, it's intolerable.</p>