title: Generating random values from uniform distribution with setting a seed in T-SQL
body: <p>I would like to generate a random value from the uniform distribution with mean=0 and a standard devation=1 for every row of a given data table in T-SQL. Additionally, I would like to set a seed in order to ensure reproducibility of analysis. Here are the ideas which did not work:</p>
  <ol>
  <li><p>Using the function <code>RAND()</code> with a declared number does not fulfill this objective: the same random value is generated for every row of the data set.</p>
  </li>
  <li><p>Such a solution:</p>
  <p><code>SELECT ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) AS [RandomNumber]</code></p>
  </li>
  </ol>
  <p>does not solve the problem either since it is not reproducible.</p>
  <p><strong>EDIT:</strong></p>
  <p>The performance does matter since my table has hundreds of millions of records.</p>