My stored procedure:
CREATE PROCEDURE spSomeStoredProcedure AS
BEGIN
SELECT CategoryName FROM Categories ORDER BY CategoryName
SELECT Top 10 CompanyName FROM Customers ORDER BY CompanyName
END
GO
I tried to use ISQLQuery, but List() method returns data only from the first SELECT