"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