How to return multiple values from stored procedures

How to return multiple values from stored procedures to reports in sql server 2005

Hello,

Do you mean multiple resultsets from a single stored procedure? This is not supported, Reporting Services will only use the first one. You could break up your stored procedure so that each resultset would populate it's own dataset in the report.

Hope this helps.

Jarret

|||Not possible, one resultset only.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||thanx