I am sure there are lots of ways but one rather easy way is to add a column
and fill it with a randomly generated number. Then use that with the TOP 60
PERCENT to get the rows you want.
Andrew J. Kelly
SQL Server MVP
"Deborah Bohannon" <dbohannonnationalcarenetwork.com> wrote in message
news:OIRMw4WRDHA.2332TK2MSFTNGP10.phx.gbl...60%> I have a recordset with approx. 189,000 records in it. I need to do an
> ysis based on random groupings of the data. For instance, on random> of the records within a certain criteria, I want to apply one part of the
> ysis, and for the remaining 40% another part of the ysis.
> Is there a way to choose a percentage of random records for querying?
> Thanks in advance for your help.