DOH, you're so smart... thanks...

But I still want to know why!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! :w00t:

LOL

hi Lynn,

The number of months between 1900-01-01 and 9999-12-31 is 97199...

My query does produce the 61 rows (or months) and it still throws up the error... so am i doing...

I want your machine, dangit...

I ran it again, it does produce the 61 rows but I also get the error thrown up... here is a pic

But this code I posted first thing, if i paste this into my query on SQL Sever Management Studio I get the error... is this the code you copied and...

1 MILLION which is below the size of an integer correct

that is my exact code... running in a query... but it is a function where the begin and end dates will be passed in...

Hi,

Thanks for replying... can you tell I'm sitting here waiting...lol

I am on SQL 2000, is that a difference? With the where clause it's totally ignoring it and mine goes...