TR_MKTMARKETINGPLAN_INSERTUPDATE_CURRENCY

CREATE trigger dbo.[TR_MKTMARKETINGPLAN_INSERTUPDATE_CURRENCY] on dbo.[MKTMARKETINGPLAN]
after insert, update 
not for replication
as
begin
  set nocount on;

  update dbo.[MKTMARKETINGPLAN] set
    [MKTMARKETINGPLAN].[BASECURRENCYID] = dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY](),
    [MKTMARKETINGPLAN].[CHANGEDBYID] = [MKTMARKETINGPLAN].[CHANGEDBYID],
    [MKTMARKETINGPLAN].[DATECHANGED] = [MKTMARKETINGPLAN].[DATECHANGED]
  from inserted
  inner join dbo.[MKTMARKETINGPLAN] on inserted.[ID] = [MKTMARKETINGPLAN].[ID]
  where [MKTMARKETINGPLAN].[BASECURRENCYID] is null;
end