CREATE PROC ellenorzes
    @szid int
AS
    DECLARE @n AS int;
    SET @n=0;
    DECLARE @m1 AS int;DECLARE @m2 AS int;
    DECLARE @n1 AS FLOAT;DECLARE @n2 AS FLOAT;DECLARE @n3 AS FLOAT;
    DECLARE @a1 AS int;DECLARE @a2 AS int;
    DECLARE c1 CURSOR
    FOR
    SELECT szt.Mennyiseg, szt.NettoAr, szt.AFAKulcs, mt.Mennyiseg, mt.NettoAr, t.NettoAr, a.ID
    FROM SzamlaTetel szt
    INNER JOIN MegrendelesTetel mt ON szt.MegrendelesTetelID=mt.ID
    INNER JOIN Termek t ON mt.TermekID=t.ID
    INNER JOIN Afa a ON t.AFAID=a.ID
    WHERE SzamlaID=@szid
    AND (szt.AFAKulcs!=a.ID OR szt.Mennyiseg!=mt.Mennyiseg OR
    mt.NettoAr!=szt.NettoAr OR t.NettoAr!=mt.NettoAr OR t.NettoAr!=szt.NettoAr);
BEGIN
    OPEN c1;
    FETCH NEXT FROM c1 INTO @m1, @n1, @a1, @m2, @n2, @n3, @a2;

    WHILE @@FETCH_STATUS = 0
    BEGIN
    SET @n=1;
        PRINT CAST(@m1 AS nvarchar(10))+','+CAST(@n1 AS nvarchar(10))+','+CAST(@a1 AS nvarchar(10))+','+CAST(@m2 AS nvarchar(10))+','+CAST(@n2 AS nvarchar(10))+','+CAST(@n3 AS nvarchar(4))+','+CAST(@a2 AS nvarchar(10));
        FETCH NEXT FROM c1 INTO @m1, @n1, @a1, @m2, @n2, @n3, @a2;
    END;

    CLOSE c1;
    DEALLOCATE c1;
    RETURN @n;
END