No you missed my point. Your trigger that you are working will not handle multiple row inserts/updates. When writing triggers you need to be careful to build things set based so you can handle that.

When you have a variable equal to a column in INSERTED you can't handle that.

[/quote]

So what would I have to change to get this to work as a trigger...