Is there a way, on one single sql statement, to insert data to one data source from another data source?
I will have the need to create bunch of "duplicate" type buttons where you click a button and it will pull all the data from table A, Data source A and dump that data into Table B, data source B.
In the past I would just create a select statement on table A, data source A, then an insert statement on Table B, data source B with the resulting data from the first query.
However, i'm looking at thousands of fields here now and I'd prefer to not do that if possible.
both servers will be SQL, both at different physical locations, but with a VPN pipe between the two.