Is there a way to exec SP into a temp table?
Hi all
I'm doing some troubleshooting, and I'd like to insert the return set of a stored procedure into a temp table. Since it's 75 columns, I'd rather not do a CREATE TABLE and define every column.
Is there a way to 'SELECT * INTO #tmp FROM exec sp_my_proc'?
SQL 2008R2.
Thanks in advance.
Jim
I'm doing some troubleshooting, and I'd like to insert the return set of a stored procedure into a temp table. Since it's 75 columns, I'd rather not do a CREATE TABLE and define every column.
Is there a way to 'SELECT * INTO #tmp FROM exec sp_my_proc'?
SQL 2008R2.
Thanks in advance.
Jim
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.