I have this table where I can return a list of rows for a specific date range.
The row it is pulling from has a more data in it than I need so I’ve reduced that down using a case when
SELECT case when w.[description] like '%Provisioning%' then left (w.[description],charindex('Provisioning',w.[description])-2) else '' end as [Application] FROM [Table 1] as w left join [Table2] as i on i.https://stackoverflow.com/q/72568367 = w.[owner] where [owner_name] in ('Specific_Owner') and (convert(datetime,dateadd(s,w.[created]/1000,'1970-01-01'),110) BETWEEN Convert(datetime, '2022-05-09' ) AND Convert(datetime, '2022-06-01' )) and w.[description] not like '%Approve%'
Which gives an output as below:
I would like to return a count of each application
So something like
Struggling a bit with this one! Any help would be appreciated 🙂
Leave an answer