TR_MKTSEGMENTATIONACTIVE_IU_ORGANIZATIONAMOUNTS (Trigger)

        
          create trigger [dbo].[TR_MKTSEGMENTATIONACTIVE_IU_ORGANIZATIONAMOUNTS] on [dbo].[MKTSEGMENTATIONACTIVE] 
          after insert, update 
          not for replication
          as
          begin
            set nocount on;
  
            if update(VARIABLECOST) or update(TOTALCOST) or update(COSTPERDOLLARRAISED) or update(TOTALGIFTAMOUNT) or update(AVERAGEGIFTAMOUNT)
              or update(ROIAMOUNT) or update(EXPECTEDCOSTPERDOLLARRAISED) or update(EXPECTEDTOTALGIFTAMOUNT) or update(EXPECTEDAVERAGEGIFTAMOUNT)
              or update(EXPECTEDROIAMOUNT) or update(INDIRECTTOTALGIFTAMOUNT) or update(INDIRECTAVERAGEGIFTAMOUNT)
              or update(UNRESOLVEDTOTALGIFTAMOUNT) or update(UNRESOLVEDAVERAGEGIFTAMOUNT)
            begin
              declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY](); 

              update
                dbo.[MKTSEGMENTATIONACTIVE]
              set
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONVARIABLECOST] = [MKTSEGMENTATIONACTIVE].[VARIABLECOST],
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONTOTALCOST] = [MKTSEGMENTATIONACTIVE].[TOTALCOST],
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONCOSTPERDOLLARRAISED] = [MKTSEGMENTATIONACTIVE].[COSTPERDOLLARRAISED],
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONTOTALGIFTAMOUNT] = [MKTSEGMENTATIONACTIVE].[TOTALGIFTAMOUNT],
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONAVERAGEGIFTAMOUNT] = [MKTSEGMENTATIONACTIVE].[AVERAGEGIFTAMOUNT],
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONROIAMOUNT] = [MKTSEGMENTATIONACTIVE].[ROIAMOUNT],
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONEXPECTEDCOSTPERDOLLARRAISED] = [MKTSEGMENTATIONACTIVE].[EXPECTEDCOSTPERDOLLARRAISED],
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONEXPECTEDTOTALGIFTAMOUNT] = [MKTSEGMENTATIONACTIVE].[EXPECTEDTOTALGIFTAMOUNT],
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONEXPECTEDAVERAGEGIFTAMOUNT] = [MKTSEGMENTATIONACTIVE].[EXPECTEDAVERAGEGIFTAMOUNT],
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONEXPECTEDROIAMOUNT] = [MKTSEGMENTATIONACTIVE].[EXPECTEDROIAMOUNT],
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONINDIRECTTOTALGIFTAMOUNT] = [MKTSEGMENTATIONACTIVE].[INDIRECTTOTALGIFTAMOUNT],
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONINDIRECTAVERAGEGIFTAMOUNT] = [MKTSEGMENTATIONACTIVE].[INDIRECTAVERAGEGIFTAMOUNT],
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONUNRESOLVEDTOTALGIFTAMOUNT] = [MKTSEGMENTATIONACTIVE].[UNRESOLVEDTOTALGIFTAMOUNT],
                [MKTSEGMENTATIONACTIVE].[ORGANIZATIONUNRESOLVEDAVERAGEGIFTAMOUNT] = [MKTSEGMENTATIONACTIVE].[UNRESOLVEDAVERAGEGIFTAMOUNT],
                [MKTSEGMENTATIONACTIVE].[BASECURRENCYID] = @ORGANIZATIONCURRENCYID,
                [MKTSEGMENTATIONACTIVE].[CHANGEDBYID] = [MKTSEGMENTATIONACTIVE].[CHANGEDBYID],
                [MKTSEGMENTATIONACTIVE].[DATECHANGED] = [MKTSEGMENTATIONACTIVE].[DATECHANGED]
              from
                inserted
                inner join dbo.[MKTSEGMENTATIONACTIVE] on inserted.ID = [MKTSEGMENTATIONACTIVE].[ID]
              where
                ([MKTSEGMENTATIONACTIVE].[BASECURRENCYID] is null or [MKTSEGMENTATIONACTIVE].[BASECURRENCYID] = @ORGANIZATIONCURRENCYID)
                and
                  (
                    [MKTSEGMENTATIONACTIVE].[ORGANIZATIONVARIABLECOST] <> [MKTSEGMENTATIONACTIVE].[VARIABLECOST]
                    or [MKTSEGMENTATIONACTIVE].[ORGANIZATIONTOTALCOST] <> [MKTSEGMENTATIONACTIVE].[TOTALCOST]
                    or [MKTSEGMENTATIONACTIVE].[ORGANIZATIONCOSTPERDOLLARRAISED] <> [MKTSEGMENTATIONACTIVE].[COSTPERDOLLARRAISED]
                    or [MKTSEGMENTATIONACTIVE].[ORGANIZATIONTOTALGIFTAMOUNT] <> [MKTSEGMENTATIONACTIVE].[TOTALGIFTAMOUNT]
                    or [MKTSEGMENTATIONACTIVE].[ORGANIZATIONAVERAGEGIFTAMOUNT] <> [MKTSEGMENTATIONACTIVE].[AVERAGEGIFTAMOUNT]
                    or [MKTSEGMENTATIONACTIVE].[ORGANIZATIONROIAMOUNT] <> [MKTSEGMENTATIONACTIVE].[ROIAMOUNT]
                    or [MKTSEGMENTATIONACTIVE].[ORGANIZATIONEXPECTEDCOSTPERDOLLARRAISED] <> [MKTSEGMENTATIONACTIVE].[EXPECTEDCOSTPERDOLLARRAISED]
                    or [MKTSEGMENTATIONACTIVE].[ORGANIZATIONEXPECTEDTOTALGIFTAMOUNT] <> [MKTSEGMENTATIONACTIVE].[EXPECTEDTOTALGIFTAMOUNT]
                    or [MKTSEGMENTATIONACTIVE].[ORGANIZATIONEXPECTEDAVERAGEGIFTAMOUNT] <> [MKTSEGMENTATIONACTIVE].[EXPECTEDAVERAGEGIFTAMOUNT]
                    or [MKTSEGMENTATIONACTIVE].[ORGANIZATIONEXPECTEDROIAMOUNT] <> [MKTSEGMENTATIONACTIVE].[EXPECTEDROIAMOUNT]
                    or [MKTSEGMENTATIONACTIVE].[ORGANIZATIONINDIRECTTOTALGIFTAMOUNT] <> [MKTSEGMENTATIONACTIVE].[INDIRECTTOTALGIFTAMOUNT]
                    or [MKTSEGMENTATIONACTIVE].[ORGANIZATIONINDIRECTAVERAGEGIFTAMOUNT] <> [MKTSEGMENTATIONACTIVE].[INDIRECTAVERAGEGIFTAMOUNT]
                    or [MKTSEGMENTATIONACTIVE].[ORGANIZATIONUNRESOLVEDTOTALGIFTAMOUNT] <> [MKTSEGMENTATIONACTIVE].[UNRESOLVEDTOTALGIFTAMOUNT]
                    or [MKTSEGMENTATIONACTIVE].[ORGANIZATIONUNRESOLVEDAVERAGEGIFTAMOUNT] <> [MKTSEGMENTATIONACTIVE].[UNRESOLVEDAVERAGEGIFTAMOUNT]
                    or (
                        [MKTSEGMENTATIONACTIVE].[TOTALGIFTAMOUNT] = 0 and [MKTSEGMENTATIONACTIVE].[TOTALCOST] = 0 and [MKTSEGMENTATIONACTIVE].[VARIABLECOST] = 0
                        and [MKTSEGMENTATIONACTIVE].[COSTPERDOLLARRAISED] = 0 and [MKTSEGMENTATIONACTIVE].[AVERAGEGIFTAMOUNT] = 0 and [MKTSEGMENTATIONACTIVE].[ROIAMOUNT] = 0
                        and [MKTSEGMENTATIONACTIVE].[EXPECTEDCOSTPERDOLLARRAISED] = 0 and [MKTSEGMENTATIONACTIVE].[EXPECTEDTOTALGIFTAMOUNT] = 0 and [MKTSEGMENTATIONACTIVE].[EXPECTEDAVERAGEGIFTAMOUNT] = 0
                        and [MKTSEGMENTATIONACTIVE].[EXPECTEDROIAMOUNT] = 0 and [MKTSEGMENTATIONACTIVE].[INDIRECTTOTALGIFTAMOUNT] = 0 and [MKTSEGMENTATIONACTIVE].[INDIRECTAVERAGEGIFTAMOUNT] = 0
                        and [MKTSEGMENTATIONACTIVE].[UNRESOLVEDTOTALGIFTAMOUNT] = 0 and [MKTSEGMENTATIONACTIVE].[UNRESOLVEDAVERAGEGIFTAMOUNT] = 0
                        )
                  );
            end
          end