SQL Kiwi (1/15/2012)

---

Sergiy (1/15/2012)

---

How happy are those people about this one: Cursor loop executes before the first row of the cursor is fetched? Or Main routine executes before any of...

cengland0 (1/16/2012)

---

L' Eomot Inversé (1/15/2012)

---

Well, I managed to get this one wrong, but only because I guessed wrongly as to which of the incorrect options would count as "correct". ...

Well, I managed to get this one wrong, but only because I guessed wrongly as to which of the incorrect options would count as "correct". It's a good question...

Have you tried the "check for solutions onlune" button?

I think you might do well to set the recovery model of the dev database to "simple", and make sure that the last thing your copy routine does is call...

I don't see this as repeating groups in the first place; "repeating groups" is a topic that's much misunderstood, with some people classifying far more things as repeating groups than...

GSquared (1/13/2012)

---

On the Raiserror piece being right for the job, my only problem with it is that it requires significantly more documentation when used that way than a more explicit...

Jack Corbett (1/13/2012)

---

I wouldn't delete it. I...

GSquared (1/13/2012)

---

Tom, is there something I'm not seeing here? Here's what Jared's response looked like:

SQLKnowItAll (1/11/2012)

---

I...

Looks to me like an extremely complex problem that has...

That's quite clear as far as it goes, but it leaves some questions open. You seem to think that it's something that can be written as a single SQL...

stephen99999 (1/13/2012)

---

I think the best way to do this is to just test on various sample data. Really change it up, and see if you can "break" the code. If...

Divine Flame (1/13/2012)

---

L' Eomot Inversé (1/12/2012)

---

edit: I haven't looked at the posting history - just the the thread referenced here and the first thread it references - so maybe I'm...

Sergeiy,

As Paul said, there's no better way to see what's actually going on than to watch it in a debugger. I gather you haven't done that (because you don't...

Evil Kraig F (1/12/2012)

---

On a side note, SQL Know It All is someone I'll be watching for. I get where he's coming from but I might be able to...