>>I somehow duplicated it 2 days ago. And in my case with even worse result - same ID for two different customers / sales.
>
>Are you absolutely sure that they are accidental duplicates or fantom records? I ask because sometimes in quoting systems a record is kept to show each quote that was presented to a prospective customer and those records are kept for historical purposes. The changedate makes me wonder...
>
>There are some times when non-normalized data is required.
The records are absolute duplicates - each field is the same. I see your point, though - may be it's intentional?
Also for the particular ConfigID I was seeing the duplicates in addition to two same records there was another record with the same ConfigID and Type, but different date and customer's info. The top cursor result in my screen shot demonstrated that.
If it's not broken, fix it until it is.
My Blog