DECLARE P CURSOR FOR SELECT pil, vol, vd, va
                     From Vol
                     order by pil
DECLARE @pil int
DECLARE @lpil int
DECLARE @vol int
DECLARE @vd varchar(20)
DECLARE @va varchar(20)
OPEN P
FETCH FROM P INTO @pil, @vol, @vd, @va
set @lpil = @pil
WHILE (@@FETCH_STATUS = 0)
BEGIN
    PRINT concat('Pilote N° :', @pil)
    Print '       Liste vol'
    PRINT 'N° Vol    VD    VA    HD'
    while ( @lpil = @pil and @@FETCH_STATUS = 0)
    BEGIN
        print concat(@vol ,'   ', @vd,'    ', @va)
        FETCH FROM P INTO @pil, @vol, @vd, @va
    END
    set @lpil = @pil
END