mattster1010
03-16-2010, 03:15 AM
Morning,
I have a table that I need to de-duplicate. I need a de-duplicator that will look at the first two fields in a table, Employee No and week ending date. I would like the de-duplicator to check against the previous record to see if these two values are the same as the current record.
Does anyone have any idea's how I may approach this?
Regards,
Matt
I have a table that I need to de-duplicate. I need a de-duplicator that will look at the first two fields in a table, Employee No and week ending date. I would like the de-duplicator to check against the previous record to see if these two values are the same as the current record.
Does anyone have any idea's how I may approach this?
Regards,
Matt