TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_INSERTUPDATE_CURRENCY (Trigger)

        
CREATE trigger dbo.[TR_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_INSERTUPDATE_CURRENCY] on dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE]
after insert, update 
not for replication
as
begin
  set nocount on;

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