DECLARE @person_id INT, @ibes_tkr CHAR(6), @rtr_id INT, @rtr_estimate_id INT, @code INT, @person_id2 INT, @tmp_code NVARCHAR(10), @cccnt int, @cm nvarchar(100)
set @cccnt = 1 -- счётчик записей
SET @tmp_code = NULL
DECLARE cur_exc CURSOR FOR
SELECT DISTINCT pite.person_id, pite.rtr_id, pite.rtr_estimate_id
FROM #person_ibes_tmp_exc pite
JOIN #ibes_broker_analyst iba ON iba.ibes_tkr = pite.ibes_tkr AND iba.rtr_id = pite.rtr_id

OPEN cur_exc
FETCH cur_exc INTO @person_id, @rtr_id, @rtr_estimate_id
WHILE @@FETCH_STATUS = 0
BEGIN

    DECLARE code CURSOR FOR 
    SELECT pac.maskcode FROM person_analyst_code pac WHERE person_id = @person_id

    OPEN code
    FETCH code INTO @code
    WHILE @@fetch_status = 0
    BEGIN
        DECLARE person2 SCROLL CURSOR FOR
        SELECT pac.person_id FROM person_analyst_code pac WHERE maskcode = @code

        OPEN person2
-- поиск по одному параметру
        FETCH person2 INTO @person_id2
        WHILE @@fetch_status = 0
        BEGIN
            IF EXISTS
            (SELECT prx.person_id, prx.analyst_code, prx.ctb_id 
            FROM person_xref prx 
            WHERE prx.analyst_code IS NOT NULL AND prx.analyst_code IS NOT NULL AND prx.end_date IS NULL
                  AND prx.person_id = @person_id2 AND prx.ctb_id = ISNULL(@rtr_estimate_id,-1))
            BEGIN
                SELECT TOP 1 @tmp_code = prx.analyst_code 
                FROM person_xref prx 
                WHERE prx.analyst_code IS NOT NULL AND prx.analyst_code IS NOT NULL AND prx.end_date IS NULL
                AND prx.person_id = @person_id2 AND prx.ctb_id = ISNULL(@rtr_estimate_id,-1)

                BREAK
            END
            ELSE FETCH person2 INTO @person_id2
        END
-- поиск по другому параметру, если по первому не найдено соответствие
        IF @tmp_code IS NULL
        BEGIN
            FETCH FIRST person2 INTO @person_id2
            WHILE @@fetch_status = 0
            BEGIN
                IF EXISTS 
                (SELECT prx.person_id, prx.analyst_code, prx.ctb_id 
                FROM person_xref prx 
                WHERE prx.analyst_code IS NOT NULL AND prx.analyst_code IS NOT NULL AND prx.end_date IS NULL
                      AND prx.person_id = @person_id2 AND prx.ctb_id = @rtr_id)
                BEGIN
                    SELECT TOP 1 @tmp_code = prx.analyst_code 
                    FROM person_xref prx 
                    WHERE prx.analyst_code IS NOT NULL AND prx.analyst_code IS NOT NULL AND prx.end_date IS NULL
                    AND prx.person_id = @person_id2 AND prx.ctb_id = @rtr_id

                    BREAK
                END
                ELSE FETCH person2 INTO @person_id2
            END
        END

      	UPDATE #person_ibes_tmp_exc
        SET analyst_code = @tmp_code
        WHERE (person_id = @person_id)  AND (ISNULL(rtr_estimate_id,-1) = ISNULL(@rtr_estimate_id,-1)) AND (rtr_id = @rtr_id) and (analyst_code is null)
        
        select @cccnt /*номер обрабатываемой записи*/, @person_id, @rtr_id, @rtr_estimate_id, @tmp_code
        SET @tmp_code = NULL

        CLOSE person2
        DEALLOCATE person2
    FETCH code INTO @code
    END
    CLOSE code
    DEALLOCATE code

set @cccnt = @cccnt+1
FETCH cur_exc INTO @person_id, @rtr_id, @rtr_estimate_id
END
CLOSE cur_exc
DEALLOCATE cur_exc

where pite.person_id in (12756658,12132733)

select @@version