putting a stored procedure directly into a temp table?

[tokuzumi]

I want to insert the results of a stored procedure directly into a temp table. Is there a way to do that without first declaring the temp table? Using TSQL, you can do it like this;

select field1, field2, field3
into #table
from tablename

If I try to do this:
exec storedprocname param1, param2
into #table

I get "Incorrect syntax near keyword 'into'"

I would rather save some code, and not declare the tables, if I don't have to. Any ideas? Thanks in advance.

 

[ClaireHCM]

Try
insert into #table exec storedprocname param1, param2


but your stored procedure should do only select statement

 

[tokuzumi]

Here is what I ended up doing:

I created a UDF, that returns a table, that returns the same recordset as the stored procedure I was trying to execute. Then I used the following syntax;

select * into #table from dbo.udfname(param1,param2)

Using that methodology, it works like a champ.