INSERT INTO Localserver.database.schema.MyLocalTable
SELECT * FROM RemoteServer.Database.Schema.MyRemoteTable
WHERE MyConditions