10 lines
562 B
SQL
10 lines
562 B
SQL
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 |