Hi,
I'm trying to understand a large storedprocedure with multiple
select statments like around 15 or so. I'm a little new to multiple
result sets.



The reader populates fields by incrementing an integer index for each
field in a row not by table tnames

The read uses nextresult() to move to the next restult set....

My Question is: Is the order of the resultsets in the Reader the same
as the order of Select statements in the stored procedure? I suppose
I should have a result set for every select statement?

Just wondered how this stuff works.

Thanks,
Tony C.

Tony C. (me (AT) here (DOT) com) writes:
Yes, the result sets are returned in the reader, in the order they are
produced in SQL Server. Note that it is the run-time order that matters.
That is, if the code goes:

CREATE PROCEDURE baaaaad_sp AS
GOTO bottom
top: SELECT 989 AS xyz
RETURN
bottom: SELECT getdate() AS now
GOTO top

The first result set will be the date, and the second result set will the
number.




--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Thank you Very Much!
Tony C.