Thank you very much for your comments and your critique. I knew the question was difficult, and perhaps meant it to be somewhat tricky (using the transaction is valid, but does not perform as you might at first expect... unless you are Jim). However I did not intend for it to be confusing or unclear. I apologize if there was part that did not make sense on the first read. I hoped most people would take the SQL statements from the question and try to run them, similar to what Diana did. Using the exact statements provided, two will execute and two will not. I do appreciate the feedback (both above and hopefully below this post), and will incorporate your suggestions in future articles and QODs.

Thanks!

Chad