Group and count by time increment?

[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:

[fuhrj]

Posting this to help somebody in the future:

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