Randomizing Data

Question

User1088344998 posted
What's the best way to randomize data being passed into a SqlDataReader? The data can't be duplicated anywere.

Answer 1

User-2077437193 posted
Check out this SQLTeam.com article: Using NEWID to Randomly Sort Records Assuming you are using SQL Server 7.0+, you can do: SELECT * FROM TableName ORDER BY NEWID() and the results will be randomized. hth

Answer 2

User1088344998 posted
Thanks Scott! I'll try that. Jason

Answer 3

User1088344998 posted
That did work! Awesome!!! Thanks again Scott! I was unaware that SQL had the function! :-D

Answer 4

User-2077437193 posted
Glad to hear it! :-) I have added a FAQ at DataWebControls.com - Returning Data in Random Order with NEWID(). Take care.

Answer 5

User1088344998 posted
Thanks! I've also added a small note on my SQL Blog brought to developers by the "SqlJunkies", Donny Mack and Doug Seven. You can read about it here http://sqljunkies.com/weblog/j_gaylord/posts/229.aspx.