USP_CONSTITUENTDUPLICATESEARCHPROCESS_ASSIGNKEYS

create procedure dbo.USP_CONSTITUENTDUPLICATESEARCHPROCESS_ASSIGNKEYS
(
    @ISINCREMENTAL bit
)
as
begin

    if @ISINCREMENTAL = 0
    begin
        with KEYS(_key_in, _key_out) as
        (
            select
                A._key_in,
                B._key_in
            from dbo.CONSTITUENTDUPLICATESEARCHPROCESSFULLRESULTS A
            inner join dbo.CONSTITUENTDUPLICATESEARCHPROCESSFULLRESULTS B on 
                A._key_CONSTITID = B.CONSTITID and 
                B.CONSTITID = B._key_CONSTITID
        )
        update dbo.CONSTITUENTDUPLICATESEARCHPROCESSFULLRESULTS set 
            CONSTITUENTDUPLICATESEARCHPROCESSFULLRESULTS._key_out = KEYS._key_out
        from KEYS
        where CONSTITUENTDUPLICATESEARCHPROCESSFULLRESULTS._key_in = KEYS._key_in
    end
    else
    begin
        with KEYS(_key_in, _key_out) as
        (
            select
                A._key_in,
                B._key_in
            from dbo.CONSTITUENTDUPLICATESEARCHPROCESSINCREMENTALRESULTS A
            inner join dbo.CONSTITUENTDUPLICATESEARCHPROCESSINCREMENTALRESULTS B on 
                A._key_CONSTITID = B.CONSTITID and 
                B.CONSTITID = B._key_CONSTITID
        )
        update dbo.CONSTITUENTDUPLICATESEARCHPROCESSINCREMENTALRESULTS set 
            CONSTITUENTDUPLICATESEARCHPROCESSINCREMENTALRESULTS._key_out = KEYS._key_out
        from KEYS
        where CONSTITUENTDUPLICATESEARCHPROCESSINCREMENTALRESULTS._key_in = KEYS._key_in
    end

end