SQL Server Performance Forum – Threads Archive

Help with multi resultset

Hi, I have a SP that returns more than one resultset and I want to use both the resultsets in my SQL Report.
But, on calling that SP from SQL Report only the first resultset is fetched and displayed. Is there any way of including the second resultset in the Dataset so that I can display the data contained in the second resultset also? Thanks, Bijesh

---

From BOL: Reporting Services supports stored procedures that return only one set of data. If a stored procedure returns multiple result sets, only the first one is used.

---

Thanks Pete! It seems I will have to change my SP to make it work. Thanks, Bijesh

---

]]>