TR_BATCHDIRECTMARKETINGEFFORTTESTSEGMENT_INSERTUPDATE_CURRENCY

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

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