title: One T-SQL query output to multiple record sets
body: <p>Don't ask for what, but i need two tables from one SQL query.</p>
  
  <p>Like this...</p>
  
  <pre><code>Select Abc, Dgf from A
  </code></pre>
  
  <p>and result are two tables</p>
  
  <pre><code>abc
  1
  1
  1
  
  dgf
  2
  2
  2
  </code></pre>
  
  <p>More details?
  Ok lets try.</p>
  
  <p>Now i have sp like this:</p>
  
  <pre><code>    SELECT a.* from ActivityView as a with (nolock) 
  where a.WorkplaceGuid = @WorkplaceGuid
  
      SELECT b.* from ActivityView as a with (nolock) 
  left join PersonView as b with (nolock) on a.PersonGuid=b.PersonGuid  where a.WorkplaceGuid = @WorkplaceGuid 
  </code></pre>
  
  <p>It's cool. But execution time about 22 seconds. I do this because in my programm i have classes that automaticly get data from records set. Class Activity and class Person. That why i can't make it in one recordset. Program didn't parse it.</p>