title: SqlDataAdapter not returning rows
body: <p>I have a <code>SqlDataAdapter</code> that I use to call a stored procedure that returns three result sets that are to fill a <code>DataSet</code>.</p>
  
  <p>The adapter works great for the 2nd and 3rd result sets, but the first one only returns the schema and not any rows.</p>
  
  <p>The stored procedure is written using a CTE to pull the first result set and calls two additional stored procedures for the 2nd and 3rd result sets.</p>
  
  <p>Any thoughts or suggestions as to what I can check?  My thoughts are that the issue lies between the database and the C# app.  I am thinking that the <code>SqlDataAdapter</code> is having an issue with the CTE.</p>