title: Multiple select statements in a stored procedure for use in classic ASP
body: <p>Currently I have a classic asp application, and one of the page has logic like this:</p>
  
  <pre><code>SELECT * FROM Table1 WHERE Condition
  //DO stuff
  SELECT * FROM Table2 WHERE Condition
  //DO stuff
  SELECT * FROM Table3 WHERE Condition
  //Execute
  </code></pre>
  
  <p>I need to convert this into a stored procedure.  Now I know how to use stored procedures in ASP generally, but I don't know how to do it with multiple selects.  How can I generate three sets of data and use them properly?</p>
  
  <p>Thanks.</p>