How to insert values into a table when executing a sp??

• aaa121

  SSCertifiable

  Points: 5902

  More actions

  June 20, 2007 at 7:21 am

  #117443

  Hi All,

  I need to be able to insert the values returned from an SP directly into a table without altering the SP. Can this be done on the EXEC command line?

  Thanks

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  June 20, 2007 at 8:01 am

  #714114

  Yes this can be done.

   

  insert into tablename exec spname parameters

  remeber to have the values returning by your sp in the same order as the table column

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• aaa121

  SSCertifiable

  Points: 5902

  More actions

  June 20, 2007 at 8:14 am

  #714119

  Great. Thanks - I knew there was a way