I would also say that a pre-requisite for a question is at least having typed it into Google first. While lmgtfy.com is funny, it gets boring after about 40 times.

🙂

I was a...

I like the fact that you can participate in a thread here, disagree thoroughly with someone, thrash it out,...

Also loving the image on the 500 page

Steve Jones - Editor (10/9/2009)

---

Just an FYI, since THE THREAD is so heavily visited. We've started our own ASK site at ask.sqlservercentral.com. Not my idea, and I'm not sure how...

Try putting SET NOCOUNT ON in your proc before the update.

Is there a compelling need to do it in VBS? If you can use .NET then it's relatively easy - there's an event on SqlConnection that you just hook on...

Listen to Wayne.

Sterling - GBP 😀

Do I get to keep the remaining 1.19639 cents or is there tax?

I have to say, that there's a lot of people in the world who get on their high horses about 'compliance' and 'maintainability', but rarely dip into actual mechanics. The...

Ahh I see - interesting he didn't update the article 😀

I see results on my boxes as being faster for 2000 & 2005 and equitable on 2008, using that method....

The article concludes:

'I ran these tests several times on a few different servers, and ISNULL appears to pretty consistently out-perform COALESCE by an average of 10 or 12 percent.'

?

+50 cool points for you sir 🙂

A quote from Orbital: 'It's better to regret something...

Or just write a simple C# app to hook up to the DB, write out the data you want.

I don't really 'get' people using stored procedures to write stuff to...