USP_MERGETASK_CONSTITUENTSITES

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

                    declare @CHANGEDATE datetime = getdate();

                    update 
                        dbo.CONSTITUENTSITE
                    set 
                        CONSTITUENTID = @TARGETID, 
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CHANGEDATE
                    where 
                        CONSTITUENTID = @SOURCEID
                    and 
                        ID not in
                        (
                            select a.ID
                            from dbo.CONSTITUENTSITE a
                            inner join dbo.CONSTITUENTSITE b
                            on a.SITEID = b.SITEID
                            where a.CONSTITUENTID = @SOURCEID
                            and b.CONSTITUENTID = @TARGETID
                        )

                    return 0;