Okay...I thought of the redesign too, but the situation warrants this design. Why is it that everyone always assumes there is no place for this design?

I got the solution I...

Totally elegant...Thanks it worked great.  Sushila--Thanks too, while I was waiting for the elegant solution I was still able to test the page.

Paully21

Thanks...I was hoping for one of those elegant non-cursor solutions, but I was thinking last night too, this might NEED a cursor.

BTW, that code was spot on...I was pretty much...

Yep...Totally the problem in fact.  I changed it to account for multiple records and everything is fine.

Note to previous poster...By many Batch_Ids I meant like 20.

Got it...

Colleague put a trigger on the table that was causing the error.  Thanks for helping me!

Nope...Copied it right from Query Analyzer just like you see it