Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • 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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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