Getting a random set of records from a table?
From: Douglas Scott <dsscott_at_ev1.net>
Date: Wed, 24 Nov 1999 18:18:13 -0600
Message-ID: <383C8043.6CC24DDB_at_ev1.net>
[Quoted] One of my users has a requirement to report on a random set of parts from our inventory database every month (need about 40 records) to satisfy an audit. This is a government audit requirement (its anybodys guess why they want this). Does anyone know an easy way to get a random set of records from a table?
Date: Wed, 24 Nov 1999 18:18:13 -0600
Message-ID: <383C8043.6CC24DDB_at_ev1.net>
[Quoted] One of my users has a requirement to report on a random set of parts from our inventory database every month (need about 40 records) to satisfy an audit. This is a government audit requirement (its anybodys guess why they want this). Does anyone know an easy way to get a random set of records from a table?
Douglas Scott
dsscott_at_ev1.net
Received on Thu Nov 25 1999 - 01:18:13 CET