CASE in T-SQL is used to return a value. Pretend the whole statement is a literal and you'll be using it correctly. You can't use it for conditional execution, only to return a conditional value.

Most of the time, it could save the changes with maybe 2-3 UPDATE statements, and that's it.<BR><BR>So, like the title says, I want to find out what SQL statement caused a trigger to fire. have ...