title: Groovy SQL Multiple ResultSets
body: <p>I am calling a stored procedure from my Groovy code. The stored proc looks like this</p>
  
  <p><code>SELECT * FROM blahblahblah</code></p>
  
  <p><code>SELECT * FROM suchAndsuch</code></p>
  
  <p>So basically, two <code>SELECT</code> statements and therefore two <code>ResultSets</code>.</p>
  
  <pre><code>sql.eachRow("dbo.testing 'param1'"){ rs -&gt;
      println rs
  }
  </code></pre>
  
  <p>This works fine for a single ResultSet. How can I get the second one (or an arbitrary number of ResultSets for that matter).</p>