I have a table with about 800,000 records and the records are organized as such:
PLANT_ID, PROJ_NUM, START_DATE, END_DATE
The problem that I am having is that some plants have more than one entry where the only difference is the dates. This is unnecessarily increasing the amount of records...