Get list of elements and their values from an untyped xml fragment in T-SQL

Posted by Kevin on Stack Overflow See other posts from Stack Overflow or by Kevin
Published on 2010-04-27T17:40:44Z Indexed on 2010/04/27 17:43 UTC
Read the original article Hit count: 295

Filed under:
|

Similiar to question: http://stackoverflow.com/questions/2266132/how-can-i-get-a-list-of-element-names-from-an-xml-value-in-sql-server

How would I also get the values for the list of elements.

For example: a1 b1 c1

Would return Element | Value A | a1 B | b1 C | c1

© Stack Overflow or respective owner

Related posts about tsql

Related posts about Xml