Thanks. I decided to write both the before and after records. It is working and I am happy. I tried to change to if exists but I was getting errors.

This...

The instead of trigger would not update the original table tbl_participant and this needs to happen. The logx_tblparticipant is a table where I am capturing the modifications made to the...

This is what I have right now in my trigger. I am getting error messages when I try to compare If i.ssn <> d.ssn, what I want to do is...