parse xml

I need to parse the above xml such that it returns the attributes in a flat
format,
e.g. abc,123
How can this be achieved using sql 2005

HiYou can use openxml function.Regards, Balaji

Hi

You can use openxml function.

Regards, Balaji

Try this:DECLARE @xml XMLSET @xml = '<SampleXML><Tables><Table value="abc"

Try this:

DECLARE @xml XML

SET @xml = '<SampleXML>


SELECT
root.x.value('(Table/@value, Field/@value)[1]', 'VARCHAR(50)') AS a,
root.x.value('(Table/@value, Field/@value)[2]', 'VARCHAR(50)') AS b
FROM @xml.nodes('SampleXML/*') root(x)