title: Update a table column with shuffled numbers within a range
body: <p>I want to update a table column -<code>Code</code>- with shuffled numbers within its range, with no duplicates and without missing a number from the range. 
  for example the range is 1-9 and the following is the table:</p>
  
  <pre><code>Id|Name|Code
  
  1 | AC | 2  
  2 | AB | 1  
  3 | CB | 5  
  4 | DE | 9  
  5 | FE | 3  
  6 | AE | 4  
  7 | FD | 6  
  8 | BD | 7  
  9 | DC | 8  
  </code></pre>
  
  <p>I want result like in the above example. I am using <code>SQL Server 2008</code>.  </p>