I NEED TO USE WHILE EXACLY AS MANY TIMES AS IT IS NEEDEt.
I MEEN I CAN SET while @z < 3 but if It is nesessary to do loop more than it will be a problem
If i will set the loop to do 20 circles than it will be a problem because of memory...
SO I NEED TO DESCRIBE WHILE TO DO EXACT NUMBER OF LOOPS AS IT IS NEEDEt.


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