8 lines
622 B
SQL
8 lines
622 B
SQL
select versionid, procid, itemid, xsection.value('@OriginalSteps', 'char(1)') originalsteps, xprocedure.value('@SectionStart', 'int') sectionstart from
|
|
(select versionid, procid, vi.itemid, cast(cc.config as xml) xconfig, cast(pcc.config as xml) xpconfig from vefn_GetVersionProcedureItems('') vi
|
|
join contents cc on vi.contentid = cc.contentid
|
|
join items pii on vi.procid = pii.itemid
|
|
join contents pcc on pcc.contentid = pii.contentid
|
|
where procid = 133172 and cc.type between 10000 and 19999) t1
|
|
cross apply xconfig.nodes('//Section') tsection(xsection)
|
|
cross apply xpconfig.nodes('//Procedure') tprocedure(xprocedure) |