title: insert using select distinct
body: <p>Let's say, I have 2 tables t1 and t2.</p>
  
  <pre><code>create table t1 
  {
  id int not null,
  col1 int null,
  col2 int null,
  col3 int null
  }
  
  create table t2
  {
  id uniqueidentifier not null,
  col1 int null,
  col2 int null,
  col3 int null
  }
  </code></pre>
  
  <p>I want to insert the below resultset into table t2.</p>
  
  <pre><code>select distinct col1, col2, col3 from t1
  </code></pre>
  
  <p>How can I achieve this using a query? I tried below statement but I know it's syntactically wrong.</p>
  
  <pre><code>insert into t2
  select newid(), distinct col1, col2, col3 from t1
  </code></pre>