TR_MKTSPONSORSHIPMAILINGTEMPLATE_INSERTUPDATE_CURRENCY (Trigger)

        
create trigger dbo.[TR_MKTSPONSORSHIPMAILINGTEMPLATE_INSERTUPDATE_CURRENCY] on dbo.[MKTSPONSORSHIPMAILINGTEMPLATE]
after insert, update 
not for replication
as
begin
  set nocount on;

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