TR_MKTMEMBERSHIPMAILINGTEMPLATE_INSERTUPDATE_CURRENCY (Trigger)

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

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