Problem excecuting store thats return multiple result sets

• artud2

  SSC Rookie

  Points: 38

  More actions

  October 22, 2013 at 9:20 am

  #300309

  hello sorry i have post the last time empty by error but now this is my issue

  i have a store procedure that return multiple datasets i want to manipulate one of theses datasets to input in a datatable is this posible and how

  plese help me

• Chris Hurlbut

  SSCarpal Tunnel

  Points: 4162

  More actions

  October 23, 2013 at 1:37 pm

  #1661089

  Well I had to put results from an SP into a table and here is how I did it:

  DECLARE @rc int

  INSERT INTO [Database].[dbo].Table_to_Insert_Into ( SP_Column1 , SP_Column2)

  EXECUTE @rc = [Database].[dbo].[Sp_to_Run]

  @Parameter

  This is assuming the stored procedure returns two columns (1 or more rows) and Passing a parameter.

  Hope this helps...

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  October 23, 2013 at 2:10 pm

  #1661094

  Since you mention datatable, I assume you're using .NET?

  Take a look at MARS (multiple active result sets):

  Manipulating Data

  http://stackoverflow.com/questions/6043685/can-we-return-a-multiple-result-set-in-stored-procedure-and-how-to-handle-it-in

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP