Viewing 4 posts - 106 through 109 (of 109 total)
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...
November 2, 2012 at 3:51 pm
Is there a partition for each day? Could it possibly be made as simple as truncating that day's table?
April 25, 2012 at 12:37 pm
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...
March 19, 2012 at 11:17 am
wouldn't this actually give you all the data for a given month regardless of which year it occurred?
January 23, 2012 at 10:33 pm
Viewing 4 posts - 106 through 109 (of 109 total)