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

  • Thread starter Thread starter CaribSoft
  • Start date Start date
C

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
 
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.
Click to expand...

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.
 
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
 
Back
Top