USP_MERGETASK_CONSTITUENTINTEREST

Parameters

Parameter	Parameter Type	Mode
@SOURCEID	uniqueidentifier	IN
@TARGETID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DELETEDUPES	bit	IN
Definition

Copy


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

                    declare @CHANGEDATE datetime = getdate();

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

                    return 0;