USP_FAFEVENT_GETREVENUEOPTION_UPDATEFROMXML
Used to update a set of records defined by UFN_FAFEVENT_GETREVENUEOPTION from the given xml string.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN | |
| @XML | xml | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @CHANGEDATE | datetime | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/30/2010 11:25:47 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_FAFEVENT_GETREVENUEOPTION_UPDATEFROMXML
(
@EVENTID uniqueidentifier,
@XML xml,
@CHANGEAGENTID uniqueidentifier = null,
@CHANGEDATE datetime = null
)
as
set nocount on;
if @CHANGEAGENTID is null
exec USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
if @CHANGEDATE is null
set @CHANGEDATE = getdate()
-- build a temporary table containing the values from the XML
declare @TempTbl table (
[ALLOWGIFTTYPEONETIMEDONATION] bit,
[ALLOWGIFTTYPEPLEDGE] bit,
[ALLOWGIFTTYPERECURRING] bit,
[COPYBATCHGUID] uniqueidentifier,
[COPYSOURCEID] uniqueidentifier,
[DONORONORBEFOREDATEGIFT] datetime,
[DONORONORBEFOREDATEPLEDGE] datetime,
[ID] varchar(36),
[ISALLOWCOMPANYDONATIONS] bit,
[ISALLOWDONATIONSFROMORGS] bit,
[ISALLOWDONORTOSELECTSTARTDATEGIFT] tinyint,
[ISALLOWDONORTOSELECTSTARTDATEPLEDGE] tinyint,
[ISALLOWEVENTDONATIONS] bit,
[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR] bit,
[ISALLOWTEAMDONATIONS] bit,
[ISENABLEDONATIONS] bit,
[ISENABLEPLEDGES] bit,
[ISENABLERECURRINGGIFTS] bit,
[ISFREQUENCYAVAILONLINEANNUALLYGIFT] bit,
[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT] bit,
[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT] bit,
[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINEMONTHLYGIFT] bit,
[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINEQUARTERLYGIFT] bit,
[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT] bit,
[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT] bit,
[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINESINGLEGIFT] bit,
[ISFREQUENCYAVAILONLINESINGLEPLEDGE] bit,
[ISFREQUENCYAVAILONLINEWEEKLYGIFT] bit,
[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE] bit,
[ISPENDINGMATCHINGGIFTS] bit,
[ISREGISTRATIONREVENUE] bit,
[ISSPONSORSHIPREVENUE] bit,
[ISSTARTDATESAMEASDAYTOSUBMITGIFT] bit,
[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE] bit,
[ISUNPAIDPLEDGES] bit,
[ISUNPAIDRECURRINGGIFTS] bit,
[ISUNPAIDSPONSORSHIPREVENUE] bit,
[MAXIMUMTRANSACTIONAMOUNT] money,
[MINIMUMDONATIONAMOUNT] money,
[STARTDATEONORBEFOREGIFT] datetime,
[STARTDATEONORBEFOREPLEDGE] datetime,
[UNCONFIRMEDPARTICIPANTGIFTENTRY] bit)
insert into @TempTbl select
[ALLOWGIFTTYPEONETIMEDONATION],
[ALLOWGIFTTYPEPLEDGE],
[ALLOWGIFTTYPERECURRING],
[COPYBATCHGUID],
[COPYSOURCEID],
[DONORONORBEFOREDATEGIFT],
[DONORONORBEFOREDATEPLEDGE],
[ID],
[ISALLOWCOMPANYDONATIONS],
[ISALLOWDONATIONSFROMORGS],
[ISALLOWDONORTOSELECTSTARTDATEGIFT],
[ISALLOWDONORTOSELECTSTARTDATEPLEDGE],
[ISALLOWEVENTDONATIONS],
[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR],
[ISALLOWTEAMDONATIONS],
[ISENABLEDONATIONS],
[ISENABLEPLEDGES],
[ISENABLERECURRINGGIFTS],
[ISFREQUENCYAVAILONLINEANNUALLYGIFT],
[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE],
[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT],
[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT],
[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE],
[ISFREQUENCYAVAILONLINEMONTHLYGIFT],
[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINEQUARTERLYGIFT],
[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE],
[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT],
[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE],
[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT],
[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINESINGLEGIFT],
[ISFREQUENCYAVAILONLINESINGLEPLEDGE],
[ISFREQUENCYAVAILONLINEWEEKLYGIFT],
[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE],
[ISPENDINGMATCHINGGIFTS],
[ISREGISTRATIONREVENUE],
[ISSPONSORSHIPREVENUE],
[ISSTARTDATESAMEASDAYTOSUBMITGIFT],
[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE],
[ISUNPAIDPLEDGES],
[ISUNPAIDRECURRINGGIFTS],
[ISUNPAIDSPONSORSHIPREVENUE],
[MAXIMUMTRANSACTIONAMOUNT],
[MINIMUMDONATIONAMOUNT],
[STARTDATEONORBEFOREGIFT],
[STARTDATEONORBEFOREPLEDGE],
[UNCONFIRMEDPARTICIPANTGIFTENTRY]
from dbo.UFN_FAFEVENT_GETREVENUEOPTION_FROMITEMLISTXML(@XML)
update @TempTbl set ID = newid() where (ID is null) or (ID = '00000000-0000-0000-0000-000000000000');
if @@Error <> 0
return 1;
declare @contextCache varbinary(128);
declare @e int;
-- cache current context information
set @contextCache = CONTEXT_INFO();
-- set CONTEXT_INFO to @CHANGEAGENTID
if not @CHANGEAGENTID is null
set CONTEXT_INFO @CHANGEAGENTID;
-- delete any items that no longer exist in the XML table
delete from dbo.[FAFEVENTDONATIONOPTIONSCONFIG] where [FAFEVENTDONATIONOPTIONSCONFIG].ID in
(select ID from dbo.UFN_FAFEVENT_GETREVENUEOPTION
(
@EVENTID
)
EXCEPT select ID from @TempTbl)
select @e=@@error;
-- reset CONTEXT_INFO to previous value
if not @contextCache is null
set CONTEXT_INFO @contextCache;
if @e <> 0
return 2;
-- update the items that exist in the XML table and the db
update [FAFEVENTDONATIONOPTIONSCONFIG]
set [FAFEVENTDONATIONOPTIONSCONFIG].[ALLOWGIFTTYPEONETIMEDONATION]=temp.[ALLOWGIFTTYPEONETIMEDONATION],
[FAFEVENTDONATIONOPTIONSCONFIG].[ALLOWGIFTTYPEPLEDGE]=temp.[ALLOWGIFTTYPEPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ALLOWGIFTTYPERECURRING]=temp.[ALLOWGIFTTYPERECURRING],
[FAFEVENTDONATIONOPTIONSCONFIG].[COPYBATCHGUID]=temp.[COPYBATCHGUID],
[FAFEVENTDONATIONOPTIONSCONFIG].[COPYSOURCEID]=temp.[COPYSOURCEID],
[FAFEVENTDONATIONOPTIONSCONFIG].[DONORONORBEFOREDATEGIFT]=temp.[DONORONORBEFOREDATEGIFT],
[FAFEVENTDONATIONOPTIONSCONFIG].[DONORONORBEFOREDATEPLEDGE]=temp.[DONORONORBEFOREDATEPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ID]=temp.[ID],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWCOMPANYDONATIONS]=temp.[ISALLOWCOMPANYDONATIONS],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWDONATIONSFROMORGS]=temp.[ISALLOWDONATIONSFROMORGS],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWDONORTOSELECTSTARTDATEGIFT]=temp.[ISALLOWDONORTOSELECTSTARTDATEGIFT],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWDONORTOSELECTSTARTDATEPLEDGE]=temp.[ISALLOWDONORTOSELECTSTARTDATEPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWEVENTDONATIONS]=temp.[ISALLOWEVENTDONATIONS],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR]=temp.[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWTEAMDONATIONS]=temp.[ISALLOWTEAMDONATIONS],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISENABLEDONATIONS]=temp.[ISENABLEDONATIONS],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISENABLEPLEDGES]=temp.[ISENABLEPLEDGES],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISENABLERECURRINGGIFTS]=temp.[ISENABLERECURRINGGIFTS],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEANNUALLYGIFT]=temp.[ISFREQUENCYAVAILONLINEANNUALLYGIFT],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE]=temp.[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT]=temp.[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE]=temp.[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT]=temp.[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE]=temp.[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEMONTHLYGIFT]=temp.[ISFREQUENCYAVAILONLINEMONTHLYGIFT],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE]=temp.[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEQUARTERLYGIFT]=temp.[ISFREQUENCYAVAILONLINEQUARTERLYGIFT],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE]=temp.[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT]=temp.[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE]=temp.[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT]=temp.[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE]=temp.[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESINGLEGIFT]=temp.[ISFREQUENCYAVAILONLINESINGLEGIFT],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESINGLEPLEDGE]=temp.[ISFREQUENCYAVAILONLINESINGLEPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEWEEKLYGIFT]=temp.[ISFREQUENCYAVAILONLINEWEEKLYGIFT],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE]=temp.[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISPENDINGMATCHINGGIFTS]=temp.[ISPENDINGMATCHINGGIFTS],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISREGISTRATIONREVENUE]=temp.[ISREGISTRATIONREVENUE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISSPONSORSHIPREVENUE]=temp.[ISSPONSORSHIPREVENUE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISSTARTDATESAMEASDAYTOSUBMITGIFT]=temp.[ISSTARTDATESAMEASDAYTOSUBMITGIFT],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE]=temp.[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISUNPAIDPLEDGES]=temp.[ISUNPAIDPLEDGES],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISUNPAIDRECURRINGGIFTS]=temp.[ISUNPAIDRECURRINGGIFTS],
[FAFEVENTDONATIONOPTIONSCONFIG].[ISUNPAIDSPONSORSHIPREVENUE]=temp.[ISUNPAIDSPONSORSHIPREVENUE],
[FAFEVENTDONATIONOPTIONSCONFIG].[MAXIMUMTRANSACTIONAMOUNT]=temp.[MAXIMUMTRANSACTIONAMOUNT],
[FAFEVENTDONATIONOPTIONSCONFIG].[MINIMUMDONATIONAMOUNT]=temp.[MINIMUMDONATIONAMOUNT],
[FAFEVENTDONATIONOPTIONSCONFIG].[STARTDATEONORBEFOREGIFT]=temp.[STARTDATEONORBEFOREGIFT],
[FAFEVENTDONATIONOPTIONSCONFIG].[STARTDATEONORBEFOREPLEDGE]=temp.[STARTDATEONORBEFOREPLEDGE],
[FAFEVENTDONATIONOPTIONSCONFIG].[UNCONFIRMEDPARTICIPANTGIFTENTRY]=temp.[UNCONFIRMEDPARTICIPANTGIFTENTRY],
[FAFEVENTDONATIONOPTIONSCONFIG].CHANGEDBYID = @CHANGEAGENTID,
[FAFEVENTDONATIONOPTIONSCONFIG].DATECHANGED = @CHANGEDATE
from dbo.[FAFEVENTDONATIONOPTIONSCONFIG] inner join @TempTbl as [temp] on [FAFEVENTDONATIONOPTIONSCONFIG].ID = [temp].ID
where ([FAFEVENTDONATIONOPTIONSCONFIG].[ALLOWGIFTTYPEONETIMEDONATION]<>temp.[ALLOWGIFTTYPEONETIMEDONATION]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ALLOWGIFTTYPEONETIMEDONATION] is null and temp.[ALLOWGIFTTYPEONETIMEDONATION] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ALLOWGIFTTYPEONETIMEDONATION] is not null and temp.[ALLOWGIFTTYPEONETIMEDONATION] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ALLOWGIFTTYPEPLEDGE]<>temp.[ALLOWGIFTTYPEPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ALLOWGIFTTYPEPLEDGE] is null and temp.[ALLOWGIFTTYPEPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ALLOWGIFTTYPEPLEDGE] is not null and temp.[ALLOWGIFTTYPEPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ALLOWGIFTTYPERECURRING]<>temp.[ALLOWGIFTTYPERECURRING]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ALLOWGIFTTYPERECURRING] is null and temp.[ALLOWGIFTTYPERECURRING] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ALLOWGIFTTYPERECURRING] is not null and temp.[ALLOWGIFTTYPERECURRING] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[COPYBATCHGUID]<>temp.[COPYBATCHGUID]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[COPYBATCHGUID] is null and temp.[COPYBATCHGUID] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[COPYBATCHGUID] is not null and temp.[COPYBATCHGUID] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[COPYSOURCEID]<>temp.[COPYSOURCEID]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[COPYSOURCEID] is null and temp.[COPYSOURCEID] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[COPYSOURCEID] is not null and temp.[COPYSOURCEID] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[DONORONORBEFOREDATEGIFT]<>temp.[DONORONORBEFOREDATEGIFT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[DONORONORBEFOREDATEGIFT] is null and temp.[DONORONORBEFOREDATEGIFT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[DONORONORBEFOREDATEGIFT] is not null and temp.[DONORONORBEFOREDATEGIFT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[DONORONORBEFOREDATEPLEDGE]<>temp.[DONORONORBEFOREDATEPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[DONORONORBEFOREDATEPLEDGE] is null and temp.[DONORONORBEFOREDATEPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[DONORONORBEFOREDATEPLEDGE] is not null and temp.[DONORONORBEFOREDATEPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ID]<>temp.[ID]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ID] is null and temp.[ID] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ID] is not null and temp.[ID] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWCOMPANYDONATIONS]<>temp.[ISALLOWCOMPANYDONATIONS]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWCOMPANYDONATIONS] is null and temp.[ISALLOWCOMPANYDONATIONS] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWCOMPANYDONATIONS] is not null and temp.[ISALLOWCOMPANYDONATIONS] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWDONATIONSFROMORGS]<>temp.[ISALLOWDONATIONSFROMORGS]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWDONATIONSFROMORGS] is null and temp.[ISALLOWDONATIONSFROMORGS] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWDONATIONSFROMORGS] is not null and temp.[ISALLOWDONATIONSFROMORGS] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWDONORTOSELECTSTARTDATEGIFT]<>temp.[ISALLOWDONORTOSELECTSTARTDATEGIFT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWDONORTOSELECTSTARTDATEGIFT] is null and temp.[ISALLOWDONORTOSELECTSTARTDATEGIFT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWDONORTOSELECTSTARTDATEGIFT] is not null and temp.[ISALLOWDONORTOSELECTSTARTDATEGIFT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWDONORTOSELECTSTARTDATEPLEDGE]<>temp.[ISALLOWDONORTOSELECTSTARTDATEPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWDONORTOSELECTSTARTDATEPLEDGE] is null and temp.[ISALLOWDONORTOSELECTSTARTDATEPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWDONORTOSELECTSTARTDATEPLEDGE] is not null and temp.[ISALLOWDONORTOSELECTSTARTDATEPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWEVENTDONATIONS]<>temp.[ISALLOWEVENTDONATIONS]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWEVENTDONATIONS] is null and temp.[ISALLOWEVENTDONATIONS] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWEVENTDONATIONS] is not null and temp.[ISALLOWEVENTDONATIONS] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR]<>temp.[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR] is null and temp.[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR] is not null and temp.[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWTEAMDONATIONS]<>temp.[ISALLOWTEAMDONATIONS]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWTEAMDONATIONS] is null and temp.[ISALLOWTEAMDONATIONS] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISALLOWTEAMDONATIONS] is not null and temp.[ISALLOWTEAMDONATIONS] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISENABLEDONATIONS]<>temp.[ISENABLEDONATIONS]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISENABLEDONATIONS] is null and temp.[ISENABLEDONATIONS] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISENABLEDONATIONS] is not null and temp.[ISENABLEDONATIONS] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISENABLEPLEDGES]<>temp.[ISENABLEPLEDGES]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISENABLEPLEDGES] is null and temp.[ISENABLEPLEDGES] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISENABLEPLEDGES] is not null and temp.[ISENABLEPLEDGES] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISENABLERECURRINGGIFTS]<>temp.[ISENABLERECURRINGGIFTS]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISENABLERECURRINGGIFTS] is null and temp.[ISENABLERECURRINGGIFTS] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISENABLERECURRINGGIFTS] is not null and temp.[ISENABLERECURRINGGIFTS] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEANNUALLYGIFT]<>temp.[ISFREQUENCYAVAILONLINEANNUALLYGIFT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEANNUALLYGIFT] is null and temp.[ISFREQUENCYAVAILONLINEANNUALLYGIFT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEANNUALLYGIFT] is not null and temp.[ISFREQUENCYAVAILONLINEANNUALLYGIFT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE]<>temp.[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE] is null and temp.[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE] is not null and temp.[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT]<>temp.[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT] is null and temp.[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT] is not null and temp.[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE]<>temp.[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE] is null and temp.[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE] is not null and temp.[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT]<>temp.[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT] is null and temp.[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT] is not null and temp.[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE]<>temp.[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE] is null and temp.[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE] is not null and temp.[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEMONTHLYGIFT]<>temp.[ISFREQUENCYAVAILONLINEMONTHLYGIFT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEMONTHLYGIFT] is null and temp.[ISFREQUENCYAVAILONLINEMONTHLYGIFT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEMONTHLYGIFT] is not null and temp.[ISFREQUENCYAVAILONLINEMONTHLYGIFT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE]<>temp.[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE] is null and temp.[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE] is not null and temp.[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEQUARTERLYGIFT]<>temp.[ISFREQUENCYAVAILONLINEQUARTERLYGIFT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEQUARTERLYGIFT] is null and temp.[ISFREQUENCYAVAILONLINEQUARTERLYGIFT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEQUARTERLYGIFT] is not null and temp.[ISFREQUENCYAVAILONLINEQUARTERLYGIFT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE]<>temp.[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE] is null and temp.[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE] is not null and temp.[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT]<>temp.[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT] is null and temp.[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT] is not null and temp.[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE]<>temp.[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE] is null and temp.[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE] is not null and temp.[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT]<>temp.[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT] is null and temp.[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT] is not null and temp.[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE]<>temp.[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE] is null and temp.[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE] is not null and temp.[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESINGLEGIFT]<>temp.[ISFREQUENCYAVAILONLINESINGLEGIFT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESINGLEGIFT] is null and temp.[ISFREQUENCYAVAILONLINESINGLEGIFT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESINGLEGIFT] is not null and temp.[ISFREQUENCYAVAILONLINESINGLEGIFT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESINGLEPLEDGE]<>temp.[ISFREQUENCYAVAILONLINESINGLEPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESINGLEPLEDGE] is null and temp.[ISFREQUENCYAVAILONLINESINGLEPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINESINGLEPLEDGE] is not null and temp.[ISFREQUENCYAVAILONLINESINGLEPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEWEEKLYGIFT]<>temp.[ISFREQUENCYAVAILONLINEWEEKLYGIFT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEWEEKLYGIFT] is null and temp.[ISFREQUENCYAVAILONLINEWEEKLYGIFT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEWEEKLYGIFT] is not null and temp.[ISFREQUENCYAVAILONLINEWEEKLYGIFT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE]<>temp.[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE] is null and temp.[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE] is not null and temp.[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISPENDINGMATCHINGGIFTS]<>temp.[ISPENDINGMATCHINGGIFTS]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISPENDINGMATCHINGGIFTS] is null and temp.[ISPENDINGMATCHINGGIFTS] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISPENDINGMATCHINGGIFTS] is not null and temp.[ISPENDINGMATCHINGGIFTS] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISREGISTRATIONREVENUE]<>temp.[ISREGISTRATIONREVENUE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISREGISTRATIONREVENUE] is null and temp.[ISREGISTRATIONREVENUE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISREGISTRATIONREVENUE] is not null and temp.[ISREGISTRATIONREVENUE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISSPONSORSHIPREVENUE]<>temp.[ISSPONSORSHIPREVENUE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISSPONSORSHIPREVENUE] is null and temp.[ISSPONSORSHIPREVENUE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISSPONSORSHIPREVENUE] is not null and temp.[ISSPONSORSHIPREVENUE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISSTARTDATESAMEASDAYTOSUBMITGIFT]<>temp.[ISSTARTDATESAMEASDAYTOSUBMITGIFT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISSTARTDATESAMEASDAYTOSUBMITGIFT] is null and temp.[ISSTARTDATESAMEASDAYTOSUBMITGIFT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISSTARTDATESAMEASDAYTOSUBMITGIFT] is not null and temp.[ISSTARTDATESAMEASDAYTOSUBMITGIFT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE]<>temp.[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE] is null and temp.[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE] is not null and temp.[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISUNPAIDPLEDGES]<>temp.[ISUNPAIDPLEDGES]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISUNPAIDPLEDGES] is null and temp.[ISUNPAIDPLEDGES] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISUNPAIDPLEDGES] is not null and temp.[ISUNPAIDPLEDGES] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISUNPAIDRECURRINGGIFTS]<>temp.[ISUNPAIDRECURRINGGIFTS]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISUNPAIDRECURRINGGIFTS] is null and temp.[ISUNPAIDRECURRINGGIFTS] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISUNPAIDRECURRINGGIFTS] is not null and temp.[ISUNPAIDRECURRINGGIFTS] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISUNPAIDSPONSORSHIPREVENUE]<>temp.[ISUNPAIDSPONSORSHIPREVENUE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISUNPAIDSPONSORSHIPREVENUE] is null and temp.[ISUNPAIDSPONSORSHIPREVENUE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[ISUNPAIDSPONSORSHIPREVENUE] is not null and temp.[ISUNPAIDSPONSORSHIPREVENUE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[MAXIMUMTRANSACTIONAMOUNT]<>temp.[MAXIMUMTRANSACTIONAMOUNT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[MAXIMUMTRANSACTIONAMOUNT] is null and temp.[MAXIMUMTRANSACTIONAMOUNT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[MAXIMUMTRANSACTIONAMOUNT] is not null and temp.[MAXIMUMTRANSACTIONAMOUNT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[MINIMUMDONATIONAMOUNT]<>temp.[MINIMUMDONATIONAMOUNT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[MINIMUMDONATIONAMOUNT] is null and temp.[MINIMUMDONATIONAMOUNT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[MINIMUMDONATIONAMOUNT] is not null and temp.[MINIMUMDONATIONAMOUNT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[STARTDATEONORBEFOREGIFT]<>temp.[STARTDATEONORBEFOREGIFT]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[STARTDATEONORBEFOREGIFT] is null and temp.[STARTDATEONORBEFOREGIFT] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[STARTDATEONORBEFOREGIFT] is not null and temp.[STARTDATEONORBEFOREGIFT] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[STARTDATEONORBEFOREPLEDGE]<>temp.[STARTDATEONORBEFOREPLEDGE]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[STARTDATEONORBEFOREPLEDGE] is null and temp.[STARTDATEONORBEFOREPLEDGE] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[STARTDATEONORBEFOREPLEDGE] is not null and temp.[STARTDATEONORBEFOREPLEDGE] is null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[UNCONFIRMEDPARTICIPANTGIFTENTRY]<>temp.[UNCONFIRMEDPARTICIPANTGIFTENTRY]) or
([FAFEVENTDONATIONOPTIONSCONFIG].[UNCONFIRMEDPARTICIPANTGIFTENTRY] is null and temp.[UNCONFIRMEDPARTICIPANTGIFTENTRY] is not null) or
([FAFEVENTDONATIONOPTIONSCONFIG].[UNCONFIRMEDPARTICIPANTGIFTENTRY] is not null and temp.[UNCONFIRMEDPARTICIPANTGIFTENTRY] is null)
if @@Error <> 0
return 3;
-- insert new items
insert into [FAFEVENTDONATIONOPTIONSCONFIG]
([EVENTID],
[ALLOWGIFTTYPEONETIMEDONATION],
[ALLOWGIFTTYPEPLEDGE],
[ALLOWGIFTTYPERECURRING],
[COPYBATCHGUID],
[COPYSOURCEID],
[DONORONORBEFOREDATEGIFT],
[DONORONORBEFOREDATEPLEDGE],
[ID],
[ISALLOWCOMPANYDONATIONS],
[ISALLOWDONATIONSFROMORGS],
[ISALLOWDONORTOSELECTSTARTDATEGIFT],
[ISALLOWDONORTOSELECTSTARTDATEPLEDGE],
[ISALLOWEVENTDONATIONS],
[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR],
[ISALLOWTEAMDONATIONS],
[ISENABLEDONATIONS],
[ISENABLEPLEDGES],
[ISENABLERECURRINGGIFTS],
[ISFREQUENCYAVAILONLINEANNUALLYGIFT],
[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE],
[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT],
[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT],
[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE],
[ISFREQUENCYAVAILONLINEMONTHLYGIFT],
[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINEQUARTERLYGIFT],
[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE],
[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT],
[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE],
[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT],
[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINESINGLEGIFT],
[ISFREQUENCYAVAILONLINESINGLEPLEDGE],
[ISFREQUENCYAVAILONLINEWEEKLYGIFT],
[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE],
[ISPENDINGMATCHINGGIFTS],
[ISREGISTRATIONREVENUE],
[ISSPONSORSHIPREVENUE],
[ISSTARTDATESAMEASDAYTOSUBMITGIFT],
[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE],
[ISUNPAIDPLEDGES],
[ISUNPAIDRECURRINGGIFTS],
[ISUNPAIDSPONSORSHIPREVENUE],
[MAXIMUMTRANSACTIONAMOUNT],
[MINIMUMDONATIONAMOUNT],
[STARTDATEONORBEFOREGIFT],
[STARTDATEONORBEFOREPLEDGE],
[UNCONFIRMEDPARTICIPANTGIFTENTRY],
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED)
select @EVENTID,
[ALLOWGIFTTYPEONETIMEDONATION],
[ALLOWGIFTTYPEPLEDGE],
[ALLOWGIFTTYPERECURRING],
[COPYBATCHGUID],
[COPYSOURCEID],
[DONORONORBEFOREDATEGIFT],
[DONORONORBEFOREDATEPLEDGE],
[ID],
[ISALLOWCOMPANYDONATIONS],
[ISALLOWDONATIONSFROMORGS],
[ISALLOWDONORTOSELECTSTARTDATEGIFT],
[ISALLOWDONORTOSELECTSTARTDATEPLEDGE],
[ISALLOWEVENTDONATIONS],
[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR],
[ISALLOWTEAMDONATIONS],
[ISENABLEDONATIONS],
[ISENABLEPLEDGES],
[ISENABLERECURRINGGIFTS],
[ISFREQUENCYAVAILONLINEANNUALLYGIFT],
[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE],
[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT],
[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT],
[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE],
[ISFREQUENCYAVAILONLINEMONTHLYGIFT],
[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINEQUARTERLYGIFT],
[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE],
[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT],
[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE],
[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT],
[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINESINGLEGIFT],
[ISFREQUENCYAVAILONLINESINGLEPLEDGE],
[ISFREQUENCYAVAILONLINEWEEKLYGIFT],
[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE],
[ISPENDINGMATCHINGGIFTS],
[ISREGISTRATIONREVENUE],
[ISSPONSORSHIPREVENUE],
[ISSTARTDATESAMEASDAYTOSUBMITGIFT],
[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE],
[ISUNPAIDPLEDGES],
[ISUNPAIDRECURRINGGIFTS],
[ISUNPAIDSPONSORSHIPREVENUE],
[MAXIMUMTRANSACTIONAMOUNT],
[MINIMUMDONATIONAMOUNT],
[STARTDATEONORBEFOREGIFT],
[STARTDATEONORBEFOREPLEDGE],
[UNCONFIRMEDPARTICIPANTGIFTENTRY],
@CHANGEAGENTID,
@CHANGEAGENTID,
@CHANGEDATE,
@CHANGEDATE
from @TempTbl as [temp]
where not exists (select ID from dbo.[FAFEVENTDONATIONOPTIONSCONFIG] as data where data.ID = [temp].ID)
if @@Error <> 0
return 4;
return 0;