Any suggestions on how to move records, specifically paycheck data, in a duplicate employee record s
Any suggestions on how to move records, specifically paycheck data, in a duplicate employee record situation? The employee was previous employed, left for a few years, then returned and checks were created in the current year with a new ID. Is there a process that moves data from this current ID to the old ID and deletes the current ID that was created in error? Would SQL be required?