title: A single sql query to return as multiple tables in a dataset
body: <p>I was wondering if i can use a single query in sql server 2005 to return as a dataset in c#, asp.net 2005 into different tables.</p>
  
  <pre><code>DataSet ds = new DataSet();
  ds = new BusinessLogic.BizLogic().getData(int repID);
  for(ds != null)
  {
      txtDate.Text = ds.Tables[2].Rows[0]["Date"].ToString();
  }
  </code></pre>
  
  <p>Want to figure out, how to write the store procedure to have multiple tables.A simple example would be appreciated. Thank you! </p>