display two different resultset from single query or SP

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  August 16, 2013 at 6:22 am

  #395318

  Hi,

  I want to display capusewise cout of students as per attached excel.

  i.e. 1) first resultset will display statuswise cout of student in each campus

  2) Second result set will display Subjectwise + statuswise cout of student in each campus

  Please guide.

  Thanks

  Abhas.

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  August 16, 2013 at 7:42 am

  #1642174

  You'll want to write your procedure and build your result sets using whatever queries are necessary. Then, simply execute the two select statements at the end. You will have two distinct result sets returned.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions