November 14, 2011 at 6:56 pm
We are in the process of converting our hierarchy structure over to the new HierarchyID data model that SQL 2008 r2 provides. I have created the necessary scripts to migrate the old data into the new format, but I now need to extract the new hierarchyID data as an XML file that will be passed to the web and displayed using the jQuery jsTree plugin that our developers what to use.
I have not had much luck on Google finding any help in this on either what steps are involved, or where to get started. Any ideas where I can go look? I am fairly new to XML with SQL, but am an experienced T-SQL programmer.
Thanks for the pointers...
November 14, 2011 at 8:16 pm
Here is a tutorial on how to do it - basic level.
http://www.stylusstudio.com/sqlxml_tutorial.html
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 15, 2011 at 6:19 pm
Great site...any ideas on how to dynamically create the XML by walking the hierarchyID table so-to-speak? I found one article on cursor use (which i have experience with) to do it, but they warned of slow performance on results containing more than 2000 rows...of which mine will have.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply