August 12, 2009 at 8:33 am
How can we read the following structure in SQL 2005?
August 12, 2009 at 12:44 pm
Did you put in some XML in your post? Looks like it got stripped out (or isn't rendering in my browser)...
Could you wrap your XML within the code="xml" and /code tags?
Doing that should render your XML like below:
August 12, 2009 at 1:15 pm
ramsp (8/12/2009)
How can we read the following structure in SQL 2005?
123
M06
M10
321
M07
M11
Put it into a column or variable of the XML datatype and then use the XML methods (.query, .exists, .value, .nodes) on it.
[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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply