• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

Select into from Stored Procedure

Can I somehow use Select into with the column output from a stored procedure?
If not, what would be the best approach to capture the rows from a stored procedure?I
 
0
vd
Asked:
vd
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
The destination table has to exist:

INSERT yourtable
exec yourproc

Now if the procedure is a system procedure, you could check the code of the procedure...

CHeers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now