elmerbotha (6/19/2008)

---

I have a cursor and would like to create a temporary table for each record in that cursor. The name of each temporary table must be obtained partly from...

Heh... I didn't see the correct answer which is "If you don't write the bloody things, you don't have to worry about stuff like this!" :hehe::P:D:)

When you double click on the error, it takes you to the line causing the problem... now, lemme ask... do you see anything at all wrong with the following?

BETWEEN 639...

Heh... well said, Ted. That's why one of my favorite lines is "Really? Do you have an MS URL or some test code that proves that?" 🙂

Heh... I end up doing that all the time... someone responds to a really old thread and I just don't go back to the beginning to look when it started....

Send it to Steve Jones... he's an MVP... if he doesn't have contacts, no one has contacts... 😀

Heh... yeah... I knew that... I was just clarifyin' 😀 Wanted to amplify what you were saying because it's such a myth now.

It's amazing to me that...

Heh... I think I just gave myself an idea for an article 😉 This same fear/question get's asked a lot...

Matt Miller (6/19/2008)

---

Actually - the other person was me, and the comment centered around the "locking TempDB" urban legend that seems to pop up a lot. That got a...

Seggerman (6/19/2008)

---

Not that it matters but carrot is what, in a bunch, BunnyRabbit on Captain Kangaroo used to put up on the counter all the time

I believe the ^ (capital...

Thanks for looking for...

Ya gotta send me a copy of what you did... I'd love to see your implementation... 🙂

Ack! I see what you mean...

I'd like to see the URL for the "regulation" that started all of this... 😉

Are we all missing a good solution to the cursor problem, here?

Nope... with the correct indexing, the CLR looses in speed and maintainability. And this is a pretty rare...