SQL DISTINCT COUNT IN DATE RANGE

Try

select task_number,

count(distinct case when datepart(hour, [date]) >=0 and datepart(hour, [date]) < 12 then [OrderNumbers] END) as AM,

count(distinct case when datepart(hour, [date]) >=12 and datepart(hour, [date]) < 24 then [OrderNumbers] END) as PM FROM myTable

GROUP BY Task_Number

---

For every expert, there is an equal and opposite expert. - Becker's Law





My blog



My TechNet articles