• Thanks Phil..

    This is what I have so far...

    Is this going to copy only the changed (updated/inserted) record?

    CREATE TRIGGER update_delete ON dbo.WSI_T_CUSTOM_BENFIT_RATES

    FOR INSERT, UPDATE

    AS

    UPDATE WSI_T_CUSTOM_BENFIT_RATES_HIST

    FROM WSI_T_CUSTOM_BENFIT_RATES