title: how to combine Two recordset data to one recordset in classic asp
body: <p>I am calling two “stored procedures” using different database connection. I used two separate record sets in page but I required combining both in one record set along with sorting also required.</p>
  
  <p>Ex: two records set Rs1, Rs2</p>
  
  <h2>Rs1 data</h2>
  
  <p>Emp_code Name  Grade</p>
  
  <p>001      Bcd    A</p>
  
  <p>004  Abc    C</p>
  
  <h2>Rs2 data</h2>
  
  <p>Emp_code    Name    Grade</p>
  
  <p>002 Xyz A</p>
  
  <p>005 Zxy B</p>
  
  <h2>But I required to displaying following table with sorting (emp_code asc, name asc, grade asc)</h2>
  
  <p>Emp_code    Name    Grade</p>
  
  <p>001 Bcd A</p>
  
  <p>002 Xyz A</p>
  
  <p>004 Abc C</p>
  
  <p>005 Zxy B</p>
  
  <p>click this link it display properly</p>
  
  <p><a href="http://i.stack.imgur.com/aNLOn.jpg" rel="nofollow">http://i.stack.imgur.com/aNLOn.jpg</a></p>