Move result of a query from one server to another table on another server What are my options in moving result of a query in one server to another table on another server? Data contains ~400.000 rows so it won't be a quick one. (Both of them are SQL Server 2008 R2)  

Thanks all.
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