Page 1 of 1

Group and count by time increment?

Posted: Wed Jun 09, 2010 10:50 am
by fuhrj
I need a report that summarizes the total tickets handled every half-hour.

Example:

9:00 10 tickets
9:30 5 tickets
10:00 25 tickets
etc....

My database contains the time the ticket was created:

9:01
9:14
9:20
etc...


Has anyone written such a report? Any help is greatly appreciated.

:biggrin:

Group and count by time increment?

Posted: Wed Jun 09, 2010 1:49 pm
by fuhrj
Posting this to help somebody in the future:

http://bytes.com/topic/sql-server/answe ... e-interval