Lowell, as far as i know the inserted and deleted tables will have the details of your post in it while the trigger is firing. Thus the deleted table will have the "previous" value and the inserted table will have the "posted" value. This will work if you are updating say tables used exclusively for lookups, thus, in theory 😉 you should be able to get back a single row for the inner join.

The reason I did not want to put the sp in the trigger is maintanance, if something should change I have to change all the triggers instead of say one sp.

thx for the input.