Move result of a query from one server to another table on another server
The simplest method  which  we use is something like below


Create a table on destination server using the scripts generated from the table on the source server by right click and going through option of Tasks/Generate scripts.
Then run the below T-SQL to upload the data from source table to destination.

INSERT INTO dbo.YourTableNameHere
SELECT *
FROM [SourceServer].[SourceDatabase].dbo.YourTableNameHere


For large data movement, refer to below discussion and answer for same:

Copy a large data from sql query result