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
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor 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...

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.

All Courses

From novice to tech pro — start learning today.