USP_MERGETASK_CONSTITUENTEVENTRESTRICTION

Parameters

Parameter	Parameter Type	Mode
@SOURCEID	uniqueidentifier	IN
@TARGETID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



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

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    with TARGETRESTRICTION_CTE(ID,CONSTITUENTID,EVENTRESTRICTIONOPTIONID)
    as
    (
        select 
            CONSTITUENTRESTRICTIONOPTION.ID,
            CONSTITUENTRESTRICTIONOPTION.CONSTITUENTID,
            CONSTITUENTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID
        from
            dbo.CONSTITUENTRESTRICTIONOPTION
        where CONSTITUENTRESTRICTIONOPTION.CONSTITUENTID = @TARGETID
    )
    delete from dbo.CONSTITUENTRESTRICTIONOPTION
    from
        dbo.CONSTITUENTRESTRICTIONOPTION
        inner join TARGETRESTRICTION_CTE on CONSTITUENTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID = TARGETRESTRICTION_CTE.EVENTRESTRICTIONOPTIONID
    where 
        CONSTITUENTRESTRICTIONOPTION.CONSTITUENTID = @SOURCEID

    update
        dbo.CONSTITUENTRESTRICTIONOPTION
    set
        CONSTITUENTRESTRICTIONOPTION.CONSTITUENTID = @TARGETID,
        CONSTITUENTRESTRICTIONOPTION.CHANGEDBYID = @CHANGEAGENTID,
        CONSTITUENTRESTRICTIONOPTION.DATECHANGED = @CURRENTDATE
    where
        CONSTITUENTRESTRICTIONOPTION.CONSTITUENTID = @SOURCEID


    return 0;