title: New values for dublicated usernames - SQL Server
body: <p>I have some dublicates of usernames in my table. I want to give these new unique usernames.</p>
  <p>To find the dublicated values, I did:</p>
  <pre><code>SELECT 
      UserName,
  COUNT 
      (UserName) UserName_count
  FROM 
      NewUsers
  GROUP BY 
      UserName
  HAVING COUNT 
      (UserName)&gt; 1;
  </code></pre>
  <p>What is the proper way of creating new values to these specifically?</p>