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