title: SQL Server - Update column from data in the same table
body: <p>I have a table that looks something like this:</p>
  
  <pre><code>SetId      ID       Premium
  2012        5          Y
  2012        6          Y
  2013        5          N
  2013        6          N
  </code></pre>
  
  <p>I want to update the 2013 records with the premium values where the setid equals 2012.</p>
  
  <p>So after the query it would look like this:</p>
  
  <pre><code>SetId      ID       Premium
  2012        5          Y
  2012        6          Y
  2013        5          Y
  2013        6          Y
  </code></pre>
  
  <p>Any help greatly appreciated</p>