>Let me ask you this, What is the best way to update the values in one table with only the values that changed in the table that fired the trigger?
>
>I don't want to copy the deleted record to another table, I want to copy only the fields that change in the deleted record to another table.
The
Deleted and
Inserted tables will contain the before and after images of the changed rows. There is also a version of the IF statement, IF UPDATE, that can be used on a column by column basis.
-Mike