raotor (11/11/2011)

---

Brandie Tarvin (11/11/2011)

---

The transaction will continue to run until it's completely rolled back. Rollbacks can take a while, just like the initial execution. It depends on how far the...

Brandie Tarvin (11/11/2011)

---

That's my plan for this afternoon is to get signed up...

That's my plan for this afternoon is to get signed up and catch...

Ah. I made a couple of different errors on the above code (non-syntax). I'll post a corrected version up later for anyone wanting to use it.

EDIT:

Corrected code that prints the...

What GSquared said.

FYI: Depending on the business, you could get fired for uploading a database onto the internet. Engage in CYA. Post sample tables and sample data insert scripts...

GAH!

Thank you, guys. I knew it was something simple.

EDIT: I was also looking at the wrong bit of code in my error search.. DOH.

Given the scenario, this sounds like a homework question.

Jack Corbett (11/11/2011)

---

Congrats! I don't know how you do it AND keep up with...

Ninja's_RGR'us (11/11/2011)

---

Roy Ernest (11/11/2011)

---

Congrats Brandie. Wonderful job. 🙂 You can stop working as a DBA...

The transaction will continue to run until it's completely rolled back. Rollbacks can take a while, just like the initial execution. It depends on how far the initial transaction went....

EEEK! I just sold another story. Happy happy.

Now I have to write more.

Glad you found a solution, even if it doesn't help you right now.

It works 99.99% of the time.

...well, okay....

If you can resolve the problem by moving your WHERE clause, though, is it really that big of a deal?

I personally think you should upgrade to SP4, BTW. I'm just...

Would you actually be using a WHERE clause IRL?

Or does the WHERE clause exist only to limit your row values at the moment?