USP_MERGETASK_CONSTITUENTCORRESPONDENCE

                CREATE procedure dbo.USP_MERGETASK_CONSTITUENTCORRESPONDENCE
                (
                    @SOURCEID uniqueidentifier,
                    @TARGETID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier,
                    @DELETEDUPES bit = 0
                )
                as
                    set nocount on;

                    declare @CHANGEDATE datetime = getdate();

                    if @DELETEDUPES = 0
                        update dbo.CONSTITUENTCORRESPONDENCE
                        set CONSTITUENTID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @CHANGEDATE
                        where CONSTITUENTID = @SOURCEID
                    else
                        --Omit duplicate correspondence records if the @DELETEDUPES
                        --flag is set
                        update dbo.CONSTITUENTCORRESPONDENCE
                        set CONSTITUENTID = @TARGETID, CHANGEDBYID = @CHANGEAGENTID, DATECHANGED = @CHANGEDATE
                        where CONSTITUENTID = @SOURCEID
                        and ID not in
                        (
                            select a.ID
                            from dbo.CONSTITUENTCORRESPONDENCE a
                            inner join dbo.CONSTITUENTCORRESPONDENCE b
                            on a.CORRESPONDENCECODEID = b.CORRESPONDENCECODEID
                            and a.DATESENT = b.DATESENT
                            and a.COMMENTS = b.COMMENTS
                            where a.CONSTITUENTID = @SOURCEID
                            and b.CONSTITUENTID = @TARGETID
                        )

                    return 0;