USP_MERGETASK_DONORCHALLENGE

Parameters

Parameter	Parameter Type	Mode
@SOURCEID	uniqueidentifier	IN
@TARGETID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



                create procedure dbo.USP_MERGETASK_DONORCHALLENGE
                (
                    @SOURCEID uniqueidentifier,
                    @TARGETID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier
                )
                as
                    set nocount on;

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

                    --update sponsor records

                    update dbo.DONORCHALLENGE
                    set EXTERNALSPONSORID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @NOW
                    where EXTERNALSPONSORID = @SOURCEID;

                    --update reserved fund records

                    update dbo.DONORCHALLENGEENCUMBERED
                    set CONSTITUENTID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @NOW
                    where CONSTITUENTID = @SOURCEID;

                    return 0;