abacrotto,

Thank you for your reply. Yes, the creation of the table could be done set-based, however, it is only done once so I don't pay much attention to performance for just creating the Calendar Table. Also, When I create a Calendar table I usually put more data into it. For example I might add '2010 - Week 1' and so forth as a column for display purposes. For a daily table I might add 'Monday', 'Tuesday', etc., so I can put whatever I want for a day name rather than depend on the DATENAME() function. The while loop makes it easier to add these information only type columns.

I hope you find calendar tables useful.

Todd Fifield