title: Multiple Datasets from Stored Procedure in SSRS
body: <p>I have a stored procedure that returns multiple resultsets just as below</p>
  <pre><code>CREATE StoredProcedure sp_MultipleDataSets
  AS
  BEGIN
      SELECT EMPID, ENAME, JOB, SAL, DEPTID FROM EMP -- first result set
      SELECT DEPTID, DNAME, LOC FROM DEPT --second result set
  END
  </code></pre>
  <p>In BIDS, while creating a new report I configured the stored procedure for dataset. It creates the dataset ONLY with the columns returned from the first result set. It does not identify the second result set.</p>
  <p>How can I create datasets for both the result sets from a stored procedure like above</p>