Home Forums SQL Server 2005 SQL Server 2005 Strategies Random rows RE: Random rows
Luke L
SSC-Dedicated
Points: 35547
More actions
September 24, 2008 at 11:00 am
#876537
Just select your top 5 percent rows and order by NEWID()
To help us help you read this[/url]For better help with performance problems please read this[/url]