How to put contents of another strored proc. into a cursor or a table?

• LoorD

  SSC Veteran

  Points: 229

  More actions

  May 3, 2004 at 2:18 am

  #107902

  Hi all!

  I'm building a stored proc. that returns a table of data into another stored proc. in that receiving sp, I would like to put the returned data into a cursor, because I need to go through the contents in it. How is this possible? I can't put content returned by an execute statement into a table or a cursor. What should I do?

  -- Arto Kainu

• Stefan Ardeleanu

  SSC-Addicted

  Points: 451

  More actions

  May 3, 2004 at 3:02 am

  #504951

  have you try with

  delete #temp

  insert into #temp

  exec sp_executesql @string

  and @String is the string with that result set

  ?