No, I use custom stored function for that purpose.

-Leonard

Thanks Jeff.

I actually agree. I used this code in mySQL and it works pretty efficient. Unfortunately SQL Server not optimizing the way mySQL does. And because it has to do...

Of cause your calculations little different:

WITH --===== Itzik-Style CROSS JOIN counts from 1 to the number of days needed

E1(N) AS (

...

I believe that if you define E1 in Itzik stile join as:

E1(N) AS (

SELECT...