Home Forums SQL Server 2005 SQL Server 2005 Strategies Random rows RE: Random rows
steveb.
SSC-Forever
Points: 46733
More actions
September 24, 2008 at 11:09 am
#876543
Even easier use the TABLESAMPLE funciton in sql 2005
select * from MyTable tablesample(5 percent)
there are some limitations on this though check BOL, the smaller the number of rows in your table the less accurate the % sample will be.