title: How to use Multiple result sets in Reporting Services
body: <p>I have a stored procedure which returns multiple result sets similiar to the following:</p>
  
  <pre><code>ALTER PROCEDURE sp_XXXX 
  (
      XXXXXX
  )
  AS
  SET NOCOUNT ON
  
  SELECT XXXXXXX    
  
  
  IF @@ROWCOUNT = 0
      SELECT     XXXXXXX
  
  
  
  RETURN
  </code></pre>
  
  <p>I want my report to use the first result set if it has data or use the second one in case the first one is empty. Any help?</p>