I would like to remote query a database with a SQL statement. I would like to insert result from the query to my local SQL server.
1. connect to remote SQL server
2. perform a remote query
3. insert result insert into a table of a local database.
How do I do that