views:

27

answers:

0

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