Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pwvailla
Starting Member
31 Posts |
 Posted - 2010-12-06 : 17:42:42
|
| I have a scriptUSE G_DEVSELECT * INTO #TEMPFROM OPENQUERY (gpspgjp1, 'SELECT po_header_id, po_line_id, line_num, unit_price, quantity, unit_meas_lookup_code, item_description, attribute3, attribute4, attribute6, attribute5, closed_flag, closed_date, cancel_flag, cancel_date FROM po.po_lines_all')that affects 719077 rows from an Oracle Purchasing system. Where is this #TEMP table? Is it in SQL Server 2005? Is it on the Oracle instance?How can I use this table to perform an INSERT of these rows? Of select rows?Thanks. |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2010-12-06 : 18:02:31
|
| #TEMP is a temporary table that is created in SQL Server for this transfer. Looks like you're populating it using your Oracle connection. From my understanding, in order to access the data within that temp table you'll have to do it within the same session as the table is being created, so in that same script.Some days you're the dog, and some days you're the fire hydrant. |
 |
|
|
|
|
|
|
|
USING #TEMP Tables to do an INSERT