Bob replied to Anonymous
16-Nov-09 06:26 AM
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)