Using Stored Procedures that Return Result Sets
Go Up to Using a Stored Procedure
Stored procedures that return data in datasets, rows and columns of data, should most often be used with a query component. However, a stored procedure component can also serve this purpose.