Your right, I should clarify.

I have a stored procedure which converts data, essentially moving it from one table to another. I check the @@error variable to detect when my...