Insert Query with stored procedure
This is a discussion on Insert Query with stored procedure within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi, is it possible to create an "INSERT INTO ..... "Select from stored procedure" Query? I want to create ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:12 PM
| ||||
| ||||
 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?      |
|
02-28-2008, 05:12 PM
| ||||
| ||||
| Re: Insert Query with stored procedure "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 |
Linear Mode
