USP_MERGETASK_CONSTITUENTRECOGNITIONDEFAULTS

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

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate()

                    update dbo.REVENUERECOGNITIONDEFAULT
                    set 
                        SOURCECONSTITUENTID = @TARGETID,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where SOURCECONSTITUENTID = @SOURCEID and RECIPIENTCONSTITUENTID <> @TARGETID
                    -- Verify the target constituent doesn't already have a recognition default with the 

                    -- recipient constituent

                    and not exists
                    (
                        select 1 
                        from dbo.REVENUERECOGNITIONDEFAULT RM
                        where RM.SOURCECONSTITUENTID = @TARGETID and 
                        RM.RECIPIENTCONSTITUENTID = REVENUERECOGNITIONDEFAULT.RECIPIENTCONSTITUENTID
                    )

                    update dbo.REVENUERECOGNITIONDEFAULT
                    set 
                        RECIPIENTCONSTITUENTID = @TARGETID,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where RECIPIENTCONSTITUENTID = @SOURCEID and SOURCECONSTITUENTID <> @TARGETID
                    -- Verify the target constituent doesn't already have a recognition default with the 

                    -- source constituent

                    and not exists
                    (
                        select 1 
                        from dbo.REVENUERECOGNITIONDEFAULT RM
                        where RM.RECIPIENTCONSTITUENTID = @TARGETID and 
                        RM.SOURCECONSTITUENTID = REVENUERECOGNITIONDEFAULT.SOURCECONSTITUENTID
                    )

                    return 0;