Posted by Erland Sommarskog on 10/01/24 11:22

Ken (kenjohnson77@hotmail.com) writes:
> I've checked the Query and Value methods and have not been able to get
> them to do this for me. Is this even possible w/XQuery? Do I need to
> use OpenXML to do what I am trying to accomplish?

Look at the nodes() function.

But as David said, you should use the specific SQL 2005 newsgroups for
SQL 2005 questions. Not the least for XML/XQuery issues this can
increase the quality of reponses dramatically. :-)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]