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