title: How to read multiple result sets returned from a SQL Server stored procedure in R
body: <p>How do I capture multiple tables returned from a stored procedure call?    </p>
  
  <pre><code>conn&lt;- odbcDriverConnect('driver={SQL Server};server=server;database=db;trusted_connection=yes')
  data &lt;- sqlQuery(conn,paste("exec dbo.GetTest"),errors=FALSE)
  </code></pre>
  
  <p>It only captures the first table returned in a list.</p>