Hi Experts
i have to following system ...
i have "Employee Management System" , part of this system is attendance time, this means that i have an external elcotoric clock , and the employee put his number ,, and it stores the time of arriving and leaving automaticlay in table called "COLLECT_EMPLOYEE" .. so each employee has two recoreds each day ,, one for arriving ,, and other for leaving work,,,,
now there is another table called "ADM_WORK_FOLW_TB" , this table is much organized than the "COLLECT_EMPLOYEE" as ""COLLECT_EMPLOYEE" " is form the clock ,, and i can not modify its structure...
any way here is what i want ...
i want to make a procedure that copy the data from the "COLLECT_EMPLOYEE" table and insert it into the second table , so i want to put 2 records form the "COLLECT_EMPLOYEE" into one record in the second table ,,,, this to make each record to represnt daily movment for each employee instead of makeing 2 records for each employee in "COLLECT_EMPLOYEE" ...
hope this is clear ...
Many thanks in advance..
attaced the DDL for two tables
and two images for table data and how it suppoed to be