..., evtcnt = sum(a.evtcnt)
, dspcnt = sum(a.dspcnt)
from (
select
strdate = convert(varchar(10), Date_Time, 120)
, evtcnt = count(*)
, dspcnt = 0
from $eventdb.$eventowner.Event_Log
where Date_Time between @dtalpha and @dtomega
group by convert(varchar(10), Date_Time, 120)...