Viewing post 1 (of 1 total)
try this query
select count(*), cast(floor(cast(startTime as float)*24)/24 as datetime)
from calltable
where datediff(hh, startTime, getdate()) < 24
group by cast(floor(cast(startTime as float)*24)/24 as datetime)
order by 1 desc
April 20, 2007 at 11:48 am
#701784