Advertisement
Guest User

Untitled

a guest
Mar 5th, 2015
186
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. 1st random querry = get 10 random rows
  2. 2nd random querry = get another 10 random rows different from the 1st call
  3. .
  4. .
  5. .
  6. 10th random querry = get the last 10 rows not choosen
  7.  
  8. SELECT TOP 10 [your select list)
  9. FROM [your table]
  10. ORDER BY NEWID()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement