Hi -

Finally figured this out. It (of course) was not a problem with the stored procedure - it was doing exactly what it was told, which was to delete any records that matched the number in the InvoiceBatchDetail table. Well - there were some items created by an incorrect join in another SP that were not listed in the InvoiceBatchDetail table. As usual - no one's fault but my own.

And - on the IsError: I realized I had commented out the code that declared the handler during debugging & then when I posted it here, I removed all commented code to make it cleaner. The handler is back in & working.