My suggestion (which is a alternate of the flag being sent is ) is:
Create 2 procedures.
uspEmployeeGetAll
Select EmpID, LastName, FirstName from dbo.Employee
uspDepartmentGetAll
Select DeptID, DepartmentName from dbo.Department
Then a wrapper usp
uspEmployeesAndDepartmentsGetAll
EXEC dbo.uspEmployeeGetAll
EXEC dbo.uspDepartmentGetAll
That'll work.
If you use an IDataReader, you have more control over loading data. But you
pay for it with more code.
See my blog for an example:
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!140.entry
"Chris" <no****@nospam.comwrote in message
news:Og**************@TK2MSFTNGP06.phx.gbl...
This might be a stupid question.... I have a stored procedures, which uses
two selects. When I run the SP I get two resultsets, one very big and the
other much smaller, which is the one I want in the dataset. How do a
ensure
only the last one goes in the dataset.