capture the output of a store procedure to a table

• crab7

  Mr or Mrs. 500

  Points: 548

  More actions

  August 28, 2002 at 1:16 pm

  #58322

  I want to capture the output of a store procedure to a table.

  Seems I had read some article here concerning how to complement this, just couldn't find it.

  Thanks a lot!

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  August 28, 2002 at 1:34 pm

  #435551

  Create the table based on the recordset that will be returned from the stored procedure. Then use the INSERT statement. For instance:

  
  
  INSERT INTO MyTable
  
  (Col1, Col2, Col3, Col4)
  
  EXEC dbo.MyStoredProc
  
  

  K. Brian Kelley

  http://www.truthsolutions.com/

  Author: Start to Finish Guide to SQL Server Performance Monitoring

  http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

  K. Brian Kelley
  @kbriankelley