Recordset from a SP

• Saeed Ahmad

  SSC Veteran

  Points: 208

  More actions

  April 17, 2003 at 9:13 am

  #81594

  Hi,

  I want to return a recordset from one SP and process it in another SP. I know how cursors are returned. Please give me other options.

  Thanx in anticipation.

  Saeed

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738683

  More actions

  April 17, 2003 at 10:49 am

  #454587

  you need a table datatype to return to. Or a temp table. You can do an

  insert MyTable exec spOne

  as well to get a result set into a table.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  April 17, 2003 at 11:36 am

  #454599

  You can also use openrowset. Or return it as XML, then use OpenXML.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn