TR_MKTSEGMENTATION_IU_BASECURRENCYID (Trigger)

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

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

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