How do I insert a stored procedure result into a table?

How do I insert a stored procedure result into a table?

Insert results of a stored procedure into a temporary table

1. SELECT *
2. INTO #temp.
3. FROM OPENROWSET(‘SQLNCLI’,
4. ‘Server=192.17.11.18;Trusted_Connection=yes;’,
5. ‘EXEC [USP_Delta_Test] ADS,ADS’)
6. select * from #temp.
7. drop table #temp.

How do I add to an existing table?

To insert a row into a table, you need to specify three things:

1. First, the table, which you want to insert a new row, in the INSERT INTO clause.
2. Second, a comma-separated list of columns in the table surrounded by parentheses.
3. Third, a comma-separated list of values surrounded by parentheses in the VALUES clause.

How do you insert data into a view?

You can insert rows into a view only if the view is modifiable and contains no derived columns. The reason for the second restriction is that an inserted row must provide values for all columns, but the database server cannot tell how to distribute an inserted value through an expression.

How to insert field1 into another table in openquery?

Here is an example using three different linked servers. ( SELECT field1, field2 FROM OPENQUERY ( Server3, ‘SELECT field1, field2 FROM db.table1’ )) b –Joined with server3 Is table1 on the local server or the remote server?

What’s the best way to insert data into a SQL table?

The only reason to use OPENQUERY would be if there was a WHERE clause on the select. OPENQUERY sends the query to the IBM i and just pulls back the results. Using a 4-part name, the entire table is pulled back and the where performed locally.

Which is the fastest way to insert data into OLE DB?

After reading the link from @Charles, it would appear the SSIS from OLE DB Destination method would be the fastest method using Integration Services. If anyone disagrees, feel free to correct me.

How long does it take for openquery to complete?

The result of the openquery is 2.5 million rows. This takes roughly 2 hours to complete. The DB server is an iSeries so I ran the query with Visual Explain and the query completes in about 1 second.