October 14, 2009 at 9:48 pm
hi every one...
I am sorry if i'm being stupid....
When we look the xml data in any xml editor it shows tree like structure...
i do have a xml data with parent root which contains some data along with child root which also contain some other data... at last ... first child root will close n then parent root will close finally.
Now i want to write a t-sql query for this.. Is this possible to write a t-sql query to represent the parent root and child roots at a time....
Guys please suggest me something... It's very imp
Really thanks for your help in advance..
sam.
October 14, 2009 at 10:43 pm
Yes, this can be done with the SQL Server 2005 XML data type methods (esp. .Nodes()), and possibly recursive cte's. If you provide us with more details, we can give you a more detailed answer.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply