The following Microsoft SQL Server T-SQL code sample with an investment banking example demonstrates triggers for missing data fillin in a second table. Starting with SQL Servr 2005, the OUTPUT clause is available as well for similar task.

CREATE TRIGGER trgFillInMissingCouponRate

ON [dbo].StateTaxFreeBond

FOR INSERT,UPDATE

AS

  BEGIN

    UPDATE StateTaxFreeBondArchive

    SET    CouponRate = isnull(i.CouponRate,m.CouponRate)

    FROM   StateTaxFreeBondArchive m

           INNER JOIN inserted i

             ON m.MBCID = i.MBCID

  END