insert into table
select * from server2.db.dbo.table

insert into server1.db.dbo.table
select * from table

insert into table
select * from server3.db.dbo.table

insert into server1.db.dbo.table
select * from table

declare @xml xml, @cml varchar(max)

set @xml=(
select col1,col1,col3
from table
for xml path('tbl')
)

set @cml=CONVERT(varchar(max),@xml) -- ибо sp_executesql не принимает тип xml

exec server2.mydb.dbo.sp_executesql N'declare @xml xml
set @xml=@cml

INSERT INTO table(col1,col2,col3)
select t.col.value(''col1[1]'',''varchar(100)'') as col1,
	t.col.value(''col2[1]'',''int'') as col2,
	t.col.value(''col3[1]'',''datetime'') as col3
from @xml.nodes(''/tbl'') t(col)
',N'@cml varchar(max)',@cml

insert into table
select * from openrowset(server, 'select a, sum(b) from schema.table where field = '1' group by a')

insert into ... select...