SQLZ (4/1/2008)

---

Hey John, I am in agreement. Particularly about it becoming a habit. That said, I don't think that just because a cursor is the wrong thing to...

In defense of the first method (using WHILE 1=1):

1. Steve McConnell advocates this syntax (in Code Complete) when the language does not natively support a "Loop with test in the...

All,

Thanks for the replies. So far, it seems that the only real benefit to the "monster" script is that it allows ordinal positioning of the new column.

As for the...

Matt,

Yes, the @@fetch_status test was mistyped in the second example - proves that code should never be cut-and-pasted.

I appreciate your thoughtful answer: rather than telling me not to use...