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'?