USP_MERGETASK_CONSTITUENTSECURITYGROUPS

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

                    declare @CHANGEDATE datetime = getdate();

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

                    return 0;