Insert Query with stored procedure

Hi,

is it possible to create an "INSERT INTO .... "Select from stored
procedure" Query?

I want to create an temporary table. In this table I want to enter the data,
which I can get from an stored procedure.
But in the FROM-clause a stored procedure is not allowed?"Harald" <yixxu@.yahoo.de> wrote in message news:bfhh70$jt5$1@.online.de...
> Hi,
> is it possible to create an "INSERT INTO .... "Select from stored
> procedure" Query?
> I want to create an temporary table. In this table I want to enter the data,
> which I can get from an stored procedure.
> But in the FROM-clause a stored procedure is not allowed?

Use INSERT INTO/EXEC, e.g.,

INSERT INTO #TempTable (col1, col2, col3)
EXEC MyStoredProcedure 1, 2

Regards,
jag