Reporting with Multiple results sets

• purple-marauder

  SSC Enthusiast

  Points: 161

  More actions

  February 17, 2003 at 5:48 am

  #80830

  I have a long(ish) stored proc which returns multiple recordsets (between 10 and 50). I want to be able to produce the results in a reasonably 'pretty' format, ideally without breaking up the stored proc into lots of smaller ones. I've looked at Access .adp, but it doesn't seem to cope well (or at all!) with multiple result sets. Any ideas????

• philcart

  SSC-Forever

  Points: 47797

  More actions

  February 17, 2003 at 3:42 pm

  #449152

  Define "reasonably 'pretty' format" what output are you looking for?

  You could put together something in ASP. I believe there is a NextResult method that allows you to process multiple resultsets.

  Thanks

  Phill Carter

  --------------------
  Colt 45 - the original point and click interface