Trim a table for development...

Good morning all,

We have a fact table of approximately 21 million records that we use in production. For development purposes I'd like our developers to use the table in our development database, but they don't need that many records...probably one million is sufficient...

I'm trying to come up with a way to leave a representative sample of records in the table but because of the nature of the data the sample won't be useful to them if I simply keep the first million records...are there any suggestions on how I could delete say, every twentieth record to trim the table down that way?

Any thoughts gratefully accepted and best regards,

Steve Received on Mon Jan 28 2002 - 06:51:36 CST