TRUNCATE TABLE mytable 
 
INSERT INTO mytable (firstname, lastname, city, state) 
SELECT * FROM OPENQUERY (mylinkedserver, 'SELECT firstname, lastname,  
city, state FROM mylinkedtable') 

SELECT * INTO mytesttable 
FROM mytable 
 
TRUNCATE TABLE mytable 
 
INSERT INTO mytable 
SELECT * FROM mytesttable 
 
DROP TABLE mytesttable 

INSERT MyLocalTable (Col1, Col2, Col3)
SELECT Col1, Col2, Col3 FROM OPENQUERY(MyLinkedServer,'SELECT Col1,Col2,Col3 FROM RemoteTable') ORDER BY Col1