TR_CURRENCY_UPDATE_INSTALLATIONINFO

CREATE trigger dbo.TR_CURRENCY_UPDATE_INSTALLATIONINFO
on dbo.CURRENCY
after update
not for replication
as
begin
  update
    dbo.INSTALLATIONINFO
  set
    INSTALLATIONINFO.BUSINESSPROCESSEXPORTFORMATCURRENCYSYMBOL = CURRENCY.CURRENCYSYMBOL,
    INSTALLATIONINFO.BUSINESSPROCESSEXPORTFORMATCURRENCYDECIMALDIGITS = CURRENCY.DECIMALDIGITS
  from
    dbo.CURRENCY
  where
    INSTALLATIONINFO.ID = 1
    and CURRENCY.ISORGANIZATIONCURRENCY = 1;
end