Hi All,
I have a table of Employee Attendance in which the Employees Attendance is recorded in a Datetime Format.
This table is in SQL SERVER 2005 so does not have a time Field.
The Format is as per shown below
aDateTime emp_code CardNo
8-17-15 9:41 AM E1534516 234516
8-18-15 8:56 AM E1534517 234517
8-18-15 9:20 AM E1534516 234516
8-18-15 6:35 PM E1534517 234517
8-19-15 9:08 AM E1534517 234517
8-19-15 6:11 PM E1534517 234517
8-24-15 9:13 AM E1534517 234517
8-24-15 6:23 PM E1534517 234517
8-25-15 9:09 AM E1534517 234517
8-25-15 7:31 PM E1534517 234517
8-26-15 9:16 AM E1534517 234517
I want to Add a new column Mode in this table which will have a Value of In and Out as per the Time,
Can you help me out in how to populate the values for each Employee in this new column?
Any help regarding this is highly respected.
A Lots of Thanks in Advance for the answers provided by you.
Thanks and Regards,
Anurag
Anurag Manke