title: SQL Update column and ignore duplicate key errors
body: <p>I am looking to update a column with concatanated values from other columns in the same row. The column I am updating is unique, and do the the nature of this I will sometimes end up with duplicate key errors. I am looking to ignore these errors and simply update one of the records and ignore the other ones.</p>
  
  <p>My query looks something like this: </p>
  
  <pre><code>update [Table] set Coolname = lower(Fname) + lower(Lname)
  where Coolname like '%s' 
  and staticID=1995
  and Fname is not null 
  and Lname is not null
  </code></pre>
  
  <p>Now in the cases where Fname and Lname match in two rows, I would like for only the first records Coolname to be updated. </p>
  
  <p>Thanks. (MS SQL Server)</p>