title: SQL OUTER JOIN with NEWID to generate random data for each row
body: <p>I want to generate some test data so for each row in a table I want to insert 10 random rows in another, see below:</p>
  
  <pre><code>INSERT INTO CarFeatures 
    (carID, featureID)
  SELECT C.ID, F.ID
    FROM dbo.Cars AS C
  OUTER APPLY (
       SELECT TOP 10 ID
         FROM dbo.Features
     ORDER BY NEWID()
  ) AS F
  </code></pre>
  
  <p>Only trouble is this returns the same values for each row. How do I order them randomly?</p>