6 lines
187 B
SQL
6 lines
187 B
SQL
Select FormatID, Name
|
|
, v.value('./@id', 'varchar(255)') Macro
|
|
, v.query('.') Commands
|
|
FROM Formats
|
|
CROSS APPLY GenMac.nodes('//g') TempXML(v)
|
|
where v.value('./@id', 'varchar(255)')='C22' |