Thanks for those links! I have read the one on Tally and I completely understand the concept, especially from a performance issue. Very good stuff to know and...

Oh my.... That is seriously COOL! :w00t:

OK, I noticed something. My original code pulls from Sunday to Saturday week periods, and includes the most recent sunday to...

Yes, using 2005. I will try your changes now.

Trying your latest solution. Got a Incorrect syntax near keyword 'VALUES'

Oof... Just saw your reply. That went just a hair over my head. Would you mind adding a few comments in the code as the sections process to...

Ok, I got the goods, man! This will create the needed data to run the sql.

IF OBJECT_ID('TempDB..#WebTV_Promo_Codes', 'U') IS NOT NULL

DROP TABLE #WebTV_Promo_Codes

CREATE TABLE #WebTV_Promo_Codes

(

[ID] [int] IDENTITY(1,1)...

Thanks for your response and I have read through the thread for creating sample data. However after following the directions for creating my first table, it throws an error...