How Can I store the store the result set by using sp_execute

• Niladri Kumar Saha

  SSC Veteran

  Points: 234

  More actions

  January 4, 2005 at 11:27 pm

  #164115

  Hi,

  I am facing a problem.In a Cursor I want to run a select statement by sp_execute statement. Because I don't know the exact fieldname,and no. of fields.So all comes dynamically.That's why I am extracting the field name dynamically and try to execute the statement by execute sp_Excecute .But with that I cannot retrieve the result set.So if can anyone  help me that how can I store the result set by doing this?

   

  ---

  Thanks & Regards,

  Niladri Kumar Saha

• Kathi Kellenberger

  SSChampion

  Points: 11811

  More actions

  January 5, 2005 at 3:02 am

  #535930

  Take a look at this thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=18819

  It has some good information similar to you question.

   

  Kathi

  Aunt Kathi Data Platform MVP
  Author of Expert T-SQL Window Functions
  Simple-Talk Editor