title: RAND not different for every row in T-SQL UPDATE
body: <p>I have the follow T-SQL to update a table with test data:</p>
  
  <pre><code>UPDATE
  SomeTable
  SET
      Created = GETDATE ( ) - CAST ( RAND ( ) * 365 AS int ) ,
      LastUpdated = GETDATE ( ) - CAST ( RAND ( ) * 365 AS int )
  </code></pre>
  
  <p>I want it to pick random daes in the past year, unfortunately it uses the same date for every row.  what is the best way to get it to be random every row it updates?</p>