leonp (1/16/2009)

---

alrite ... first thanks for 'all the guidance' ....

second .. while i admit to being a little lazy, I do not have access to the database itself that...

magarity kerns (8/15/2008)

---

By the most amazing coincidence, we have just discovered a developer's query is running out of tempdb space because of the following as his join clause:

where

a.acct_nbr >...

leon mckay (1/16/2009)

---

Jeff Moden (1/16/2009)

---

The article was actually first published on 12/6/2007 and it actually says that on the SSC home page where the article was listed. Why they...

Dan Guzman (1/16/2009)

---

I'm confused. The article states it was published today 1/16/2009, yet this discussion was started 12/6/2007! Even the first 9 pages of responses are from 2007....

sknox (1/16/2009)

---

Back to the subject, this is a good article. It explains to me exactly why a few queries I've written take so long to run, and I look forward...

sfrazier (1/16/2009)

---

OK I am a simplistic TSQL programmer - I appreciated the article. I am working on some code in a payroll extract project and have run squarely into...

TheSQLGuru (1/16/2009)

---

Jeff:

1) For your follow-on articles, when you demonstrate the 'tsql trick' solution, please make sure you caveat the hell out of it about how and why you can get...

One additional thought... people always seem to fall into the trap of saying "this will never be for more than 1 row". You don't actually know how someone else...

rob jones (1/16/2009)

---

Currently i have 'set nocount on'.

Will i have to remove that in the "Update, and if @@Rowcount = 0, then insert. " method so it returns a rowcount?

If...

Outstanding. Thanks for taking the time to post your great feedback, Julie... it would be very interesting to see your code along with brief explanation if that's possible and...

krypto69 (1/16/2009)

---

Hi everyone, thanks again for all your help.

I tried Ramesh's suggestion first, but to my surprise, it was only slightly quicker.

Was then going to try Chris Morris's suggestion but...

GilaMonster (1/16/2009)

---

Order...

I pretty sure it will with an ORDER BY...

Plain and simple... I consider my salary to be in the world of private information. I would sue the pants off of any company that made my salary public...

Saw this thread and just wanted to make a note... recursion is at least as bad as a well formed cursor. Michael's post above is absolutely the way to...