The solution worked perfectly.

Not only did I become much more familiar with CTEs, but I also learned about ROW_NUMBER()! That's a great little built-in function I'll be using frequently...

Sorry to have vanished. My migration project over the weekend went LOOOONNNNNGGGG and work today was insane. I'll be looking at this tomorrow and will post back with...

Lynn Pettis (2/28/2014)

---

Give this a try:

--===== If the test table already exists, drop it

IF OBJECT_ID('tempdb..#history') IS NOT NULL

...

Thanks for the recommendations guys/gals, I really appreciate it! I'm headed home and I'm working on a migration project over the weekend. I'll try to report back on...

Thanks for the compliment. I appreciate the help and I'm happy to provide whatever you need/want to help me. 🙂 I didn't want to quote your last...

Sean Lange (2/28/2014)

---

You absolutely do not need a cursor for this. Cursors are horrible for performance as you obviously realize. We can help you but first you need to help...

Sean Lange (2/28/2014)

---

You absolutely do not need a cursor for this. Cursors are horrible for performance as you obviously realize. We can help you but first you need to help...

@jeff Moden:

You got me on the right track. I made a newbie mistake and didn't post all of the code behind this trigger; as I only posted the...

@jeff Moden:

You got me on the right track. I made a newbie mistake and didn't post all of the code behind this trigger; as I only posted...

Thanks so much for the input guys. I'll look at your recommendations today and report back. 😀