select Type,ItemID,Number,Text, xSection.query('.') qSection , xProcedure.value('@SectionStart','int') SectionStart ,isnull(xSection.value('@OriginalSteps','char(1)'),'N') OriginalSteps from (select *, cast(config as xml) xConfig from Contents where Type < 20000) CC JOIN VEFN_GetVersionProcedureItems('') VI ON VI.ContentID = CC.ContentID JOIN VEFN_GetVersionNames() VN ON VI.VersionID = VN.VersionID Outer apply xConfig.nodes('//Section') tSection(xSection) outer apply xConfig.nodes('//Procedure') tProcedure(xProcedure) Where ProcID = 21883 Order by ItemID