USP_TASKWIZARD_GETTASKS

Returns all tasks associated with a specified task wizard.

Parameters

Parameter	Parameter Type	Mode	Description
@TASKWIZARDID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_TASKWIZARD_GETTASKS
    @TASKWIZARDID uniqueidentifier
as
begin

with xmlnamespaces ('bb_appfx_task' as [t])
select
    TASKSPECXML
    , TASKSPECXML.query('/t:TaskSpec[1]/t:TaskWizardInfo[1]/t:TaskWizardList[1]/t:TaskWizard[upper-case(./@ID)=sql:variable("@TASKWIZARDID")]')
        .value('/t:TaskWizard[1]/@Sequence','int') as SEQUENCE
from 
    dbo.TASKCATALOG
where 
    TASKSPECXML.exist('/t:TaskSpec[1]/t:TaskWizardInfo[1]/t:TaskWizardList[1]/t:TaskWizard[upper-case(./@ID)=sql:variable("@TASKWIZARDID")]') = 1
order by 
    TASKSPECXML.value('/t:TaskSpec[1]/@Sequence','int')
    , 2

end