USP_MERGETASK_CONSTITUENTDOCUMENTATION

Parameters

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

Copy


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

                    declare @CHANGEDATE datetime = getdate();

                    update dbo.CONSTITUENTNOTE
                    set CONSTITUENTID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @CHANGEDATE
                    where CONSTITUENTID = @SOURCEID

                    update dbo.CONSTITUENTNOTE
                    set AUTHORID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @CHANGEDATE
                    where AUTHORID = @SOURCEID

                    update dbo.CONSTITUENTMEDIALINK
                    set CONSTITUENTID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @CHANGEDATE
                    where CONSTITUENTID = @SOURCEID

                    update dbo.CONSTITUENTMEDIALINK
                    set AUTHORID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @CHANGEDATE
                    where AUTHORID = @SOURCEID

                    update dbo.CONSTITUENTATTACHMENT
                    set CONSTITUENTID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @CHANGEDATE
                    where CONSTITUENTID = @SOURCEID

                    update dbo.CONSTITUENTATTACHMENT
                    set AUTHORID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @CHANGEDATE
                    where AUTHORID = @SOURCEID

                    return 0;