Working with temporary tables without prior declaration

Question

I have one stored procedure. I don't know the data type of the result set. I want to avoid prior declaration of table schema.

Now, I want to store the result set of procedure in a temporary table. In pseudo SQL it would look like this:

select * into #table1 exec proc_name

What would be the real SQL to do it?

I dont wanna create the schema . like :- create table #table1 (...) — Gopal, Sep 17 '13 at 12:39
@Gopal have a look at **http://stackoverflow.com/questions/653714/how-to-select-into-temp-table-from-stored-procedure** — Dhaval, Sep 17 '13 at 12:44
If you don't know the schema in advance, how can you possibly perform any useful work on the resulting table? — Damien_The_Unbeliever, Sep 17 '13 at 12:53

score 0 · Answer 1 · answered Sep 17 '13 at 14:23

0

Step 1: Create a temp tables. Say #temp Step 2:

INSERT INTO #temp
exec proc_name

answered Sep 17 '13 at 14:23

Ritesh kumar

I will create the temp table based on the output of procedure.In that case temp table will be tighty coupled with result set of proc, which I dont want..Is there any other way? – Gopal Sep 19 '13 at 05:15

1 Answers1