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

Good choice... BCP was definitely the way to go especially since you didn't want header info.  Nice job and thanks for the feedback.

Here's all the things that need to be true to do non-logged bulk inserts from BOL...

• The recovery model is simple or bulk-logged.
• The target table is not being replicated.
• The target...

Cool... Thanks again, Andrew.

Anyone else?  It would be really cool if this could be done through T-SQL without modifying SysProcesses directly... don't think it can be done but its worth asking...

Daaaang... thanks, David Coming from the likes of you, that's quite the compliment.

Heh... and I was too sleepy this morning... I shouldn't post when I'm pooped...

It is still a bit of a half cross...

Ok... I was right about the cross-join... and it took more than 3 minutes to exec on 100,000 rows.

And when I change that snippet in the function to have a...

Sure thing, JH... I don't like the looks of that unconstrained cross-join in the function, though... I think it's going to gen 65,536 internal rows every time it executes...

I'll...

I agree... so far as I'm concerned, writing directly to SysProcesses is not an option but a sub for OSQL may be what I have to find (or build).  I...

Hey, Richard... just to let you know... I can normally beat most looping functions by using a Tally table... but not this one (least ways, not so far

Thanks for the response, Andrew.  Yeah... kinda missing what I'm asking for.  OSQL doesn't have a "connection string" nor a paramter for it, but the security folks want me to...