USP_CONSTITUENTDUPLICATESEARCHPROCESS_ASSIGNKEYS_FORCURRENTAPPUSER

CREATE procedure dbo.USP_CONSTITUENTDUPLICATESEARCHPROCESS_ASSIGNKEYS_FORCURRENTAPPUSER
(
    @TABLENAME nvarchar(256)
)
as
begin

    declare @SQLTOEXEC nvarchar(max);

    set @SQLTOEXEC = 'with KEYS(_key_in, _key_out) as
        (
            select
                A._key_in,
                B._key_in
            from ' + @TABLENAME + ' A
            inner join ' + @TABLENAME + ' B on 
                A._key_CONSTITID = B.CONSTITID and 
                B.CONSTITID = B._key_CONSTITID
        )
        update ' + @TABLENAME + ' set 
            ' + @TABLENAME + '._key_out = KEYS._key_out
        from KEYS
        where ' + @TABLENAME + '._key_in = KEYS._key_in;'

    exec sp_executesql @SQLTOEXEC, N'@TABLENAME nvarchar(256)', @TABLENAME = @TABLENAME;

end