TR_MKTSEGMENTGROUP_IU_BASECURRENCYID (Trigger)

        
                    create trigger [dbo].[TR_MKTSEGMENTGROUP_IU_BASECURRENCYID] on [dbo].[MKTSEGMENTGROUP] 
                    after insert, update 
                    not for replication
                    as
                    begin
                        set nocount on;
    
                        declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY](); 

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