title: NewID() not returning a random a sample
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/13627486/random-sampling-from-a-large-dataset">Random sampling from a large dataset</a>  </p>
  </blockquote>
  
  
  
  <p>I posted a question earlier <a href="https://stackoverflow.com/questions/13627486/random-sampling-from-a-large-dataset">here</a></p>
  
  <p>And I thought that everything was fine and dandy, but when I went to check out the randomness of the result, I found that there was none.  The other aspects of the query work fine, but I'm getting the <code>top X</code> number from the table, regardless of what I try to do.  Since SQL Server doesn't allow you to use an order by clause in a subquery, how can I get around this to make sure that I'm getting a truly random sample?</p>