TR_SPONSORSHIPPROGRAM_INSERTUPDATE_CURRENCY

CREATE trigger dbo.TR_SPONSORSHIPPROGRAM_INSERTUPDATE_CURRENCY on dbo.SPONSORSHIPPROGRAM
after insert, update
not for replication
as
begin
  set nocount on;

    declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

  update dbo.SPONSORSHIPPROGRAM
  set BASECURRENCYID = @ORGANIZATIONCURRENCYID,
      CHANGEDBYID = SPONSORSHIPPROGRAM.CHANGEDBYID,
      DATECHANGED = SPONSORSHIPPROGRAM.DATECHANGED
  from inserted
  inner join dbo.SPONSORSHIPPROGRAM on SPONSORSHIPPROGRAM.ID = inserted.ID
  where SPONSORSHIPPROGRAM.BASECURRENCYID is null;
end