TR_MKTCOMMUNICATIONTEMPLATE_IU_BASECURRENCYID

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

            declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY](); 

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