Need Qry Syntax Help - Need to delete two records that are exactly the same
Posted on 2007-03-24
I accidentally inserted two records that are exactly the same into a MS SQL (2005) table. I can't delete them using the following qry:
Delete from Competitors where CompetitorID=66 and SeasonID=12 and EventID=0 and RunID=6
When I run the qry, it says 0 rows affected. The only way I know how to fix this is truncate the table and then reinsert the data. Is there another way, because there is no way I want to risk the data.
Thanks in advance!