USP_MERGETASK_CONSTITUENTNAMINGOPPORTUNITYRECOGNITION

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

                    declare @CHANGEDATE datetime = getdate();

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

                    return 0;