Editor's Note: This issue marks the debut in SQL Server Magazine of SQL Server Savvy, a collection of SQL Server tips in question-and-answer format that has run in Windows 2000 Magazine (formerly Windows NT Magazine) since 1997. Send your SQL Server questions and comments to SQL Server MVP Brian Moran at savvy@sqlmag.com.

I need to generate a query that counts the number of records, in hourly intervals, for a range of dates. The output should look something ...