Hi,
I have Query like below to calculate Total Orders entered by employer
select De. Name as 'Requesting Employer', COUNT (Distinct(Em.OrderID)) As 'Total Orders' from
EmOrders Em
INNER JOIN DEmployer De on Em.EmployerID = De.EmployerID
where (Em.OrderDateTime between '03/01/2018' and '04/01/2018')
Group By De.Name
order by De.Name
and I am using below query to find the Total Orders entered between date 0200-1100 ... Just added this condition to above query to pull Orders between 02 am to 11 am...
select De.Name as 'Requesting Employer', COUNT (Distinct(Em.OrderID)) As 'Orders Between 0200-1100' from
EmOrders Em
INNER JOIN DEmployer De on Em.EmployerID = De.EmployerID
where (Em.OrderDateTime between '03/01/2018' and '04/01/2018')
and (DATEPART(HOUR, Oe.OrderDateTime) between 2 and 10 )
Group By De.Name
order by De.Name
How can I combine above two queries ?
If (DATEPART(HOUR, Oe.OrderDateTime) between 2 and 10 ) then 'COUNT (Distinct(Em.OrderID)) ' Gives 'Orders Between 0200-1100' Column
If (DATEPART(HOUR, Oe.OrderDateTime) not between 2 and 10 ) then 'COUNT (Distinct(Em.OrderID)) ' Gives 'Orders Outside the range' Column
I need One query to calculate below columns
'Requesting Employer' 'Total Orders' 'Orders Between 0200-1100' 'Orders Outside the range'
Can anyone please help me on this ?
Thanks,
Archana