s

CREATE PROCEDURE jobbjegy AS
    while((SELECT (AVG(CAST(jegy AS FLOAT))) AS ATLAG FROM jegyek j WHERE tkod = 'in008' AND uv = (SELECT MAX(UV) FROM jegyek j2 WHERE j2.neptun = j.neptun AND TKOD = 'in008')) < 4.0)
    BEGIN
    UPDATE jegyek SET jegy = jegy+1 FROM jegyek j WHERE tkod = 'in008' AND uv = (SELECT MAX(UV) FROM jegyek j2 WHERE j2.neptun = j.neptun AND TKOD = 'in008');
    END
    PRINT 'KÉSZ';