Posted on Thursday, June 03, 2010 9:20 AM
A nice way to select random records from a table is the use of NEWID().
Example:
Select TOP 5 * from [tablename] ORDER BY NEWID()
When run the above command twice, you will see that the output differs when you have more than 5 records, of course.
see also: http://msdn.microsoft.com/en-us/library/ms190348.aspx