Page tree
Skip to end of metadata
Go to start of metadata
select distinct as Kutuphane,p.Name as SurecIsmi,
       (case when pv.Version='1.0.0' then 'Yeni' else 'Guncelleme' end) as Durum 
from   wflLibraries l left outer join
       wflProcesses p on p.Library= l.Id left outer join
       wflProcessVersions pv on pv.Process=p.Id
where DATEPART(YEAR,pv.CreateDate)=DATEPART(YEAR,dateadd(Year,-1,Getdate()))
Order By 1,2  
select distinct CompletedBy as Sayi from wflWorkItems 
where DATEPART(YEAR,EndDate)=2019
  • No labels