Sorry. I did not look closely enough at your sql.

For my purposes, the temp table is much simpler.

DECLARE @Calendar TABLE(theMonth DATETIME);

INSERT INTO @Calendar

...

Thanks, though I will probably use a tempory table for this.

The calenar code may come in handy for another project and I appreciate the support.