4 lines
169 B
SQL
4 lines
169 B
SQL
SELECT FormatID,Name,ParentID
|
|
,v.query('.') NodeItself
|
|
,v.value('@Index', 'varchar(100)') AS [MyIndex] From Formats
|
|
CROSS APPLY Data.nodes('//CheckOffHeader') TempXML(v) |