Very nice!

I didn't find two minor problems with it, however.

In step 7, where you getting the columns your are missing the TABLE_SCHEMA column in your where clause, so there will...

I got a good chuckle out of it myself....

Lynn Pettis (4/28/2009)

---

tpepin (4/28/2009)

---

Andy DBA (4/28/2009)

---

I think suggestions for proper formatting and good comments are left out of many discussions and examples because the focus is more on performance (rightly...

Andy DBA (4/28/2009)

---

I think suggestions for proper formatting and good comments are left out of many discussions and examples because the focus is more on performance (rightly so) and also...

peter (4/28/2009)

---

Stored procedures aren't bad when they are used for guiding a procedure of a series of actions; it is what they are for basically. What is bad is procedural...

Peter's explaination has already convinced me that set operations would be better. In my case, it wasn't a...

peter (4/28/2009)

---

Once you realize that each added record is basically is a complete new set operation by itself you start to see how obvious it is for procedural looping code...

Andy DBA (4/27/2009)

---

greatheep (4/27/2009)

---

So, the gauntlet is down - any suggestions on how to achieve the same benefits using set processing?

In summary, we want:

- If there is an error in...