title: Using OpenQuery With INSERT INTO Statement
body: <p>I currently use the following to data warehouse a table everday:</p>
  
  <pre><code>DROP TABLE mytable 
  
  SELECT firstcolumn, secondcolumn INTO mytable
  FROM OPENQUERY (mylinkedserver, 'SELECT firstcolumn, secondcolumn FROM linkedtable')
  </code></pre>
  
  <p>I would like to start using TRUNCATE going forward (to perserve system resources and indexes):</p>
  
  <pre><code>TRUNCATE TABLE mytable
  
  INSERT INTO mytable (firstcolumn, secondcolumn)
  ?
  </code></pre>
  
  <p>How do I use OpenQuery with the INSERT INTO statement? </p>