Kak mne sdelat' shtoby Loop byl kak raz stol'ko raz skol'ko nuzhno
kak opisat' "While" ?

declare @z int
set @z = 0

while @z < 3 // Zdes' Pomosh nuzhna

BEgin
UPDATE UMB_PERSON_ADDRESS
SET Expired = 1

FROM UMB_PERSON_ADDRESS
JOIN
( SELECT Person_id
FROM UMB_PERSON_ADDRESS
WHERE IS_MAILING_ADDRESS = 1
AND EXPIRED = 0
GROUP BY (PERSON_ID)
HAVING COUNT(*) > 1
) AS A ON UMB_PERSON_ADDRESS.PERSON_ID = A.PERSON_ID
JOIN
( SELECT PERS_ADDRESS_ID = MIN (PERS_ADDRESS_ID)
FROM UMB_PERSON_ADDRESS
WHERE IS_MAILING_ADDRESS = 1
AND EXPIRED = 0
GROUP BY (PERSON_ID)
HAVING COUNT(*) > 1
) AS B ON UMB_PERSON_ADDRESS.PERS_ADDRESS_ID = B.PERS_ADDRESS_ID
set @z = @z +1
end