Sachin Nandanwar (12/16/2010)
Use Top clause without order by clause.Select top 10 columnname from yourtable.
This would mostly give the same result again and again. Use NEWID() in the ORDER BY Clause
SELECT TOP 10 * FROM YourTable ORDER BY NEWID()
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/