title: Select/Insert only newly entered data from one table to another
body: <p>Apologies in advance for what im sure is a simple question:</p>
  
  <p>I'm attempting to put together a query that will pull new information from one table to another on a nightly basis, I can't seem to iron out the logic for selecting and inserting only new data since the last insert. My current query is this:</p>
  
  <pre><code>insert into dbo.calculationtable (ID, Server, Datetime, UptimeStatus)
  Select ID, SERVER, CheckTime, ResultType
  From dbo.sample
  GO
  </code></pre>
  
  <p>which along with some other logic in the rest of the query outputs the information im looking for, the problem is when it runs again it includes all of the previous data along with any new entries (therefore duplicating it). How would i get it to ignore those columns?</p>