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