Generating a report with a specified number of records 1

[Mary99999]

I have a table with 840,000 records (medical claims). I want the user to enter a date parameter (date the claim was paid) and generate a random list of claims paid on that date. So far, no problem. But the user wants to also put in a parameter for how many claims they want to see on the report (50 or 100, or whatever.) The purpose is an audit of a certain number of claims. Thanks.

 

[MalcolmW]

You are far better to do that at the database level. Choosing "random" records is a difficult chore, depending on how truly random you want them to be.

I would pass this off to your database developer, saying you want a stored procedure that takes as input parameters a date and a positive integer, and returns a selection of random rows for that date and in that quantity.
Malcolm

 

[Mary99999]

That sounds do-able. Our database guy is always ready to do whatever we need. Thanks very much for taking the time to answer.