I was trying to select a large dataset, from a read-only SQL Server database (that is, the data is stored on ServerA in #tmp_tbl)... and insert the data into another instance of SQL server (insert into newtable1 on ServerB)? How do I do this using two db connections?
insert into newtable1 (col1, col2) <--- newtable1 is ServerB, db connectionB
values (select col1, col2 from #tmp_tbl) <--- #tmp_tbl is ServerA, db connectionA
Do I need to write the output to a file (from ServerA.database.table), then read it again (inserting it into ServerB.database.table)?