title: How do I copy data from one table to another table on another server?
body: <p>I have a simple SQL that on a production database finds about 3000 rows:</p>
  
  <pre><code>SELECT *
  FROM [CONTOSO].[BATID] (NOLOCK)
  WHERE COMPANYNO = 1
  AND MEASURINGPOINT = '592-98901_NPT'
  AND TIMESERIESNO = 1
  AND DATE_TIME &gt;= '2013-01-31 23:00:00'
  AND DATE_TIME &lt;= '2013-02-28 22:59:00'
  ORDER BY DATE_TIME
  </code></pre>
  
  <p>Is there some way that I can convert the output into some kind of big 'INSERT INTO....'-sql that would insert this data into the same table. Then I would easily be able to copy the sql into the other SQL Server Management Studio-window and execute it.</p>