TR_BATCHDIRECTMARKETINGEFFORTPACKAGE_INSERTUPDATE_CURRENCY

CREATE trigger dbo.[TR_BATCHDIRECTMARKETINGEFFORTPACKAGE_INSERTUPDATE_CURRENCY] on dbo.[BATCHDIRECTMARKETINGEFFORTPACKAGE] 
after insert
not for replication
as
begin
  set nocount on;

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