title: sql server select distinct with ID
body: <p>I want to write a select distinct statement like this:  </p>
  
  <pre><code>INSERT INTO  Table2(ID, ColA, ColB, ColC) 
  SELECT DISTINCT ID,ColA, ColB, ColC
  FROM Table1
  </code></pre>
  
  <p>What happens now is that all data is copied because of the ID field. Can i create an insert into statement with a select distinct query which selects different data from ColA,ColB,ColC, but also inserts the ID field into Table2 without using it for the Select distinct query?</p>
  
  <p>Greetings</p>