title: SQL Server - Shuffle results randomly, but with a weight assigned to each record
body: <p>I know that the normal way to shuffle results with SQL Server is to order by <code>NEWID()</code>, except I'd like to instead use a weighted shuffle.</p>
  
  <p>Each record in my table has an integer 'Importance' from 1 to 10. I'd like to order by <code>RAND()*Importance</code>, except SQL Server has <code>RAND()</code> return the same value for each record returned.</p>
  
  <p>Any ideas please?</p>