USP_MERGETASK_CONSTITUENTSURVEY

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

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

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