How to delete records from the original table while randomly selecting the records

[CaribSoft]

I have a database of 100,000 records , I want to randomly (I known how to do
this) select say 200 records randomly , at the same time I want to delete
the randomly selected record from the original table. The random records
will be appended to a new table.

Thanks Patrick

 

[John Vinson]

I have a database of 100,000 records , I want to randomly (I known how to do
this) select say 200 records randomly , at the same time I want to delete
the randomly selected record from the original table. The random records
will be appended to a new table.

You can't do it "at the same time", i.e. not as part of the same
query; but you can create a Delete query joining the two tables,
deleting all those records from the source table which match the new
table.

 

[Baisong Wei[MSFT]]

Hi Patrick,

Thank you for using the newsgroup and I am reviewing you post. Our MVP have
provide a approach that to select the record into a new table and then
delete from the old table the record which are in the new table. I wonder
this meet your requirement or you still have questions about it.

Looking forward to your resply! Thanks

Best regards

Baisong Wei
Microsoft Online Support