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
|
Trigger Definition
