TR_SPONSORSHIPPROGRAM_INSERTUPDATE_CURRENCY (Trigger)

        
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