I tinkered with it a bit and came up with this:

It could be better (if I could write it in 2008 or better it'd work with dynamic sql too). But,you...

Is there a partition for each day? Could it possibly be made as simple as truncating that day's table?

Can't you just use a windowing function inside a stored proc? Something like this (the body of a stored proc that calls itself)

CREATE PROCEDURE piece_at_a_time @start int

AS

begin

if not exist (select...

wouldn't this actually give you all the data for a given month regardless of which year it occurred?