Link to home
Start Free TrialLog in
Avatar of Mayogroup
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.  
ASKER CERTIFIED SOLUTION
Avatar of Eyal
Eyal
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial