Help on XML parsing

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

jacob sebastian SSChampion Points: 11822 More actions · Answer 1

Iany,

This editor does not allow XML tags and hence your XML data does not show up in the post. Please replace XML tags ('<>') with '[]' and repost.

.

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 2

SELECTNode.value('../@ID', 'int') AS ServiceLineNumber,

Node.value('@Name', 'varchar(50)') as FieldName,

Node.query('New').value('.','varchar(100)') AS OldValue,

Node.query('Old').value('.','varchar(100)') AS NewValue

FROM@xml.nodes('/ServiceLine/Field') TempXML(Node)

N 56°04'39.16"
E 12°55'05.25"

jacob sebastian SSChampion Points: 11822 More actions · Answer 3

Ah, I did not notice the attachment!

May be a little easier method using a CROSS APPLY.

SELECT

Node.value('@ID','INT') AS ServiceLineNumber,

Node1.value('@Name', 'varchar(20)') as FieldName,

Node1.query('New').value('.','varchar(20)') AS OldValue,

Node1.query('Old').value('.','varchar(20)') AS NewValue

FROM @xml.nodes('/ServiceLine') t(Node)

CROSS APPLY Node.nodes('Field') t1(Node1)

/*

ServiceLineNumber FieldName OldValue NewValue

----------------- -------------------- -------------------- --------------------

1 OrderDate 1/1/2008 2/2/2008

1 Messages test t

2 ShipName Home Office

2 ShipCity NY SF

*/

.

iany SSChasing Mays Points: 659 More actions · Answer 4

SSChasing Mays

Points: 659

October 2, 2008 at 12:41 pm

Thanks!