You know... I've never read one of his books... they any good?

Sure it can... but then why spend all those brain cells trying to do it in a single query when a proc can do the same thing and maybe a...

Matt Whitfield (12/24/2008)

---

Jeff

You know what, I have to say - would it kill you to agree with what people have said rather than repeat what other people say and try...

Matt Whitfield (12/24/2008)

---

@jeff -

I tried to test the COALESCE method, but it was horrifically slow over about 10,000 rows. Also interested why you say SELECT COALESCE(@SQL .... when it's actually...

Kurt W. Zimmerman (12/24/2008)

---

Matt;

Great post! My view on this is if cursors were so bad then why does the construct even exist? Cursors have their place...

What caught my eye was the following...

That seemed to leave the problem up in the air. I wanted to...

I'm not sure why folks try to use so many bitwise integer columns. It makes the column "multi-purpose" which is not what the definition of a column actually is....

Wayne West (12/4/2008)

---

Jeff Moden (11/25/2008)

---

Wayne West (10/22/2008)

---

Thanks for the article, Ranga, very useful. I look forward to getting our ERP system into 2005 or 2008 as I know they're...

That's part of the reasoning behind the "forum ettiquette" article that so many of us have in our signature. Lot's of times, just taking that minute or two of...

Nope. I like people who...

I agree with the other's. Hat's off to Gaby for taking on a highly controversial subject.

As other's have also stated, running DBCC and certain system sprocs is one of...

Phil Parkin (12/23/2008)

---

haha, I was wondering the same and was hoping to draw out the...

Can you post the DOS command you're using... might be able to tweek it for ya.

Almost forgot... don't forget that sp_MsForEachDB is nothing but a big ol' cursor. Look at the code if you don't believe me. Also, in SQL Server 2005, you...

Good idea, Gaby, and good article...

Just a couple of tips... if you simply add Forward_Only and Read_Only to the cursor declaration to make it a "fire hose" cursor,...