2 lines
129 B
SQL
2 lines
129 B
SQL
Select FormatID, Name, v.query('.') MyNode
|
|
FROM Formats CROSS APPLY Data.nodes('//ProcDescr[(not(@MatchProcNumber))]') TempXML(v) |