USP_MERGETASK_CONSTITUENTREFUND_CREDIT

Parameters

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

Definition

Copy



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

                declare @CURRENTDATE datetime = getdate()

                update dbo.CREDITITEMMEMBERSHIP
                set 
                    GIVENBYID = @TARGETID, 
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = @CURRENTDATE
                where GIVENBYID = @SOURCEID

                update dbo.CREDITITEMEVENTREGISTRATION
                set 
                    REGISTRANTID = @TARGETID, 
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = @CURRENTDATE
                where REGISTRANTID = @SOURCEID

                update dbo.CREDIT
                set 
                    CONSTITUENTID = @TARGETID, 
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = @CURRENTDATE
                where CONSTITUENTID = @SOURCEID



                return 0;