TR_BATCHDIRECTMARKETINGEFFORT_INSERTUPDATE_CURRENCY

create trigger dbo.[TR_BATCHDIRECTMARKETINGEFFORT_INSERTUPDATE_CURRENCY] on dbo.[BATCHDIRECTMARKETINGEFFORT] 
after insert
not for replication
as
begin
  set nocount on;

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