How to get a Random Sample of 10%.

[brendasql]

I am trying to retrieve a list for a random audit of new entries in our database. The list (report) needs to be 10% of the total new entries. I have written a store proc to retrieve my number for the 10%, but I'm having a hard time trying to input this into another store proc or in VB6 code. My users will be generating this report each week using these procedures. Any help would be greatly appreciated!!!!!!!
Thanks,
B

 

[ClaireHCM]

Try this

select top 10 percent * from tbname order by newid()

 

[brendasql]

Thanks!!!! That was the solution.