I'd like to be able to insert the results of a stored procedure into a temporary table without previously defining the fields for a temporary table. I was hoping the following would work:
SELECT * INTO #temp
INSERT INTO #temp
But I haven't had success with either.
Thanks for any help!