CREATE PROC ellenorzeshiv
AS
    DECLARE @szi AS int;
    DECLARE @return_value int;
    DECLARE c2 CURSOR
    FOR
    SELECT sz.ID
    FROM Szamla sz;
BEGIN
    OPEN c2;
    FETCH NEXT FROM c2 INTO @szi;

    WHILE @@FETCH_STATUS = 0
    BEGIN
        EXEC @return_value = [dbo].[ellenorzes]
             @szid = @szi

        IF(@return_value=0)
            PRINT 'Helyes számla';

        FETCH NEXT FROM c2 INTO @szi;
    END;

    CLOSE c2;
    DEALLOCATE c2;
END