6 lines
247 B
SQL
6 lines
247 B
SQL
Select Name, --v.query('.') Query,
|
|
v.value('@Index','integer') MyIndex,
|
|
v.value('@RightCheckOffBoxChar','integer') RightCheckOffBoxChar FROM
|
|
Formats CROSS APPLY Data.nodes('//RightCheckOffBox') TempXML(v)
|
|
order by v.value('@Index','integer'),Name
|