[progress Communities] [progress Openedge Abl] Forum Post: Re: Removing Duplicates From A Table

[OctavioOlguin]

Some times, what it makes duplicate some data, it's the iterpretation that some actor on the system gives to the data, dont you think? Assuming data is at least 4NF, we can consider its economical and practically efficient for database storing, but perhaps some department gives the same value to datum with, let's say, KEY(CustNum, DateOperation) and they consider this as duplicate record (if customer showed up two times in a date), and Rus Paul was asked to create a data table with the concentrated data about this scenario... Just a thought . And Patrick Tingen showed what most of us would think as solution to the task at hand..

Continue reading...