Mayogroup
asked on
remove data from SQL table - SQL 2008 R2
A user has added approx 5000 incorrect entries into a DB. I would like to remove them.
Lets assume there are 2 columns in this table-
Serial number and Reference number.
Lets assume the incorrect serial numbers are all between 10000 and 15000.
How do I remove them?
I am not an SQL expert, so would appreciate if you can paste the query I need to run.
Lets assume there are 2 columns in this table-
Serial number and Reference number.
Lets assume the incorrect serial numbers are all between 10000 and 15000.
How do I remove them?
I am not an SQL expert, so would appreciate if you can paste the query I need to run.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.