February 2010 Blog Posts

Ad-Hoc Rollup by date/time Interval

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...