Hello,
I have a need with one stored procedure to get two sets of data, like big
table and summary (summary is to complicated to do it in Reporting service).
I manage to do it with two seperate SP, but if sp executes in like 5min,
with two SP it will be like 8-9min.
In asp.net you can do next.rocordset and can display data from second table,
can it be done in RS (2005sp2)
--
Muson
Bruce L-C [MVP] - 24 Jul 2008 14:31 GMT
No it can't. Only one recordset can be done at a time. I would look at
snapshots so this can be run ahead of time.

Signature
Bruce Loehle-Conger
MVP SQL Server Reporting Services
> Hello,
>
[quoted text clipped - 9 lines]
> --
> Muson