random selection (1 Viewer)

[iainv]

I want to run a report that will return 10% random selection of dataheld in a table. Can anybody help

 

[Rob.Mills]

I assume if you use a select statement such as this:

SELECT TOP 10 PERCENT

without giving it an ORDER BY clause then it will randomly pickup 10%.

 

[Mile-O]

Although "random" to a point, the TOP 10 PERCENT picked out the same records every time.

If you want to generate completely random records then you might want to have a look at the random test generator I posted on this thread and adapt the code.