TR_BATCHSPONSORSHIP_INSERTUPDATE_CURRENCY

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

  update
    dbo.BATCHSPONSORSHIP
  set
    BATCHSPONSORSHIP.BASECURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(),
    BATCHSPONSORSHIP.TRANSACTIONCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(),
    BATCHSPONSORSHIP.CHANGEDBYID = BATCHSPONSORSHIP.CHANGEDBYID,
    BATCHSPONSORSHIP.DATECHANGED = BATCHSPONSORSHIP.DATECHANGED
  from inserted
    inner join dbo.BATCHSPONSORSHIP on inserted.ID = BATCHSPONSORSHIP.ID
  where BATCHSPONSORSHIP.BASECURRENCYID is null
    and BATCHSPONSORSHIP.TRANSACTIONCURRENCYID is null;
end