But, that's more correlated subqueries... why not use a simple join for the WHERE EXISTS?

Heh... yeah, I crossed out the wrong part, huh?  Shouldn't post when I'm pooped.  Thanks, Serqiy.

Heh... Thanks Jacob...

Ok... apples to apples on the last bit of code... the following takes 1:09 including the PK.

--===== Create and populate a test table.

     -- Column "SomeDate"...

Nope... from BOL...

Lesser of batch size or 250 MB

Yeah... but I hate Oracle

Go for broke... read up on WITH CUBE in BOL... that's where they teach you about the GROUPING function that works both with ROLLUP and CUBE.

The outer join certainly does the trick but the subquery wasn't the problem... the fact that you made it a correlated subquery may have been.

select * from TableA

where ID not...

Jacob,

Your idea is great but your code is too complex for what it does and it takes too long to run... for example, you say the code to produce a...

I agree with Ed on both points... The fact that you are even considering some standardized method of formatting is a huge step in the right direction.  And, whatever format...

But you have the same problem commenting out the first line... Yes?

How quickly CTE's have made folks forget all about Temp Tables, Table Variables, and Views

If that's all you intend to use the Calendar table for, you can use the following along with a simple Holiday table for the same thing...

SELECT

   (DATEDIFF(dd, @StartDate,...

>>"scoop a few, ah, droppings, then write an editorial"

BWAAAA-HAAAAA-HAAAAA!!!! Oh, I laughed out loud!  Almost sounds like a prerequisite!  Way too funny!  Thanks for the great laugh, Steve!

Sometimes, ya just can't see the forest for the trees ... of course a separate table would do... if I save the SPID...

Heh... guess he got THAT answer