This is probably stupid, but can I have 3 selects in my stored
procedure and get the results back from all of them?

I have a set of data and I need to get 3 sets of totals based on
different criteria.  I've declared my tables, inserted/updated the data
in the tables and then have my 3 selects.

When I run the s.p. in Query Analyzer, I get the 3 sets of totals.
However, when I try to pull the data into a report using SQL Reporting
Services, I can only get the results from the first table.

Am I missing something here?

And, I did consider using 3 separate s.p.'s but it doesn't make sense
to do it that way.

Thanks!

I think unless you use your own datalayer which processes the data and
passes it to the report as a dataset / datatable this is not possible.
AFAIK RS will only take the first returned rowset.

HTH, jens Suessmeyer.

Why query optimizer does not select the index?
Popuate field with value from last row
Finding the right record
CHARINDEX in CASE Within SELECT Statement
Default Value Calculation