pmccue
Instructor
- Jul 29, 2006
- 18
First off, special thanks to IT4EVR and PHV and Vic for their aide. Problem is, I'm not sure I stating my problem correctly. Here goes again:
I have ~165K records with some records similar. I want to delete the similar records and retain the first instance of the record. As mentioned, one thing that's been a pain about this effort is that some of the repeating records in the original table are not duplicates, where all field values match, but are 'similar' where some field values match, like LastName, FirstName, DOB, but the other field values in the similar records may not match.
I don't see how an Append can work, since the original table and the append table would have different structures. I've worked through such as strategy but get seem to get invalid answers. There must be a script method but I will need a sample as I am not formally trained in sql scripting. If automation fails, then maybe I could use a manual approach as there appear to be about 1500 similar records that require deleting.
Thanks,
Phil....
I have ~165K records with some records similar. I want to delete the similar records and retain the first instance of the record. As mentioned, one thing that's been a pain about this effort is that some of the repeating records in the original table are not duplicates, where all field values match, but are 'similar' where some field values match, like LastName, FirstName, DOB, but the other field values in the similar records may not match.
I don't see how an Append can work, since the original table and the append table would have different structures. I've worked through such as strategy but get seem to get invalid answers. There must be a script method but I will need a sample as I am not formally trained in sql scripting. If automation fails, then maybe I could use a manual approach as there appear to be about 1500 similar records that require deleting.
Thanks,
Phil....