SQL - Tüm İş Adım ve Açıklamaları

declare @node nvarchar(100)
set @node='Task'
 
select
        l.Name as Kutuphane,
        p.Name as SurecAdi,
        ISNULL(SurecVeri.Ent.value('(./@Type)[1]','nvarchar(max)'),'Step')  as Tipi,
        SurecVeri.Ent.value('(./@Name)[1]','nvarchar(max)') as AdimAdi,
        SurecVeri.Ent.value('(./@Instructions)[1]','nvarchar(max)') as AdimAciklama
from    wflProcesses p inner  join
        wflLibraries l on l.Id=p.Library inner join
        wflProcessVersions pv on pv.Id=p.CurrentVersion cross apply
        pv.Graph.nodes('//*[local-name()=sql:variable("@node")]') as SurecVeri(Ent)