Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Help needed w/query

    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

     

     

     

Viewing post 1 (of 1 total)