I often use aggregate queries to rollup data by an arbitrary date/time interval. I'll share some techniques that I use to accomplish the task in case you find these useful, using the same table below:
CREATE TABLE dbo.WebStats
(
RequestTimestamp datetime NOT...