TR_MKTSEGMENTATIONSEGMENTACTIVE_IU_ORGANIZATIONAMOUNTS (Trigger)

        
CREATE trigger [dbo].[TR_MKTSEGMENTATIONSEGMENTACTIVE_IU_ORGANIZATIONAMOUNTS] on [dbo].[MKTSEGMENTATIONSEGMENTACTIVE] 
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(EXPECTEDROIAMOUNT)
  begin
    declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY](); 

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