Viewing 4 posts - 1 through 4 (of 4 total)
No, I use custom stored function for that purpose.
-Leonard
August 10, 2011 at 6:34 pm
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...
August 10, 2011 at 11:11 am
Of cause your calculations little different:
WITH --===== Itzik-Style CROSS JOIN counts from 1 to the number of days needed
E1(N) AS (
...
August 9, 2011 at 3:16 pm
I believe that if you define E1 in Itzik stile join as:
E1(N) AS (
SELECT...
August 9, 2011 at 1:00 pm
Viewing 4 posts - 1 through 4 (of 4 total)