USP_MERGETASK_CONSTITUENTBBNC

Parameters

Parameter	Parameter Type	Mode
@SOURCEID	uniqueidentifier	IN
@TARGETID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@MERGEUSERPROFILE	bit	IN
Definition

Copy


                CREATE procedure dbo.USP_MERGETASK_CONSTITUENTBBNC
                (
                    @SOURCEID uniqueidentifier,
                    @TARGETID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier,
          @MERGEUSERPROFILE bit = 1
                )
                as
                    set nocount on;

                    declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                    update dbo.BATCHBBNCDONATION
                    set DONORID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @CURRENTDATE
                    where DONORID = @SOURCEID;                    

                    update dbo.BATCHBBNCDONATION
                    set CORPORATEDONORID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @CURRENTDATE
                    where CORPORATEDONORID = @SOURCEID;                    

                    update dbo.BATCHBBNCDONATION
                    set MGCONSTITUENTID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @CURRENTDATE
                    where MGCONSTITUENTID = @SOURCEID;                    

                    update dbo.BATCHBBNCDONATION
                    set TRIBUTEACKNOWLEDGEELINKID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @CURRENTDATE
                    where TRIBUTEACKNOWLEDGEELINKID = @SOURCEID;                    

                    update dbo.BATCHBBNCDONATION
                    set SPOUSELINKID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @CURRENTDATE
                    where SPOUSELINKID = @SOURCEID;    

          if @MERGEUSERPROFILE = 1
            exec dbo.USP_MERGETASK_NETCOMMUNITY @SOURCEID, @TARGETID, @CHANGEAGENTID


                    return 0;