EmpCode Duty_Date Status ================================ 5001 01-Mar-12 Present 5002 02-Mar-12 Off 5003 01-Mar-12 Absent 5004 04-Mar-12 Leave 5001 02-Mar-12 Present 5002 05-Mar-12 Present 5001 03-Mar-12 Off 5005 01-Mar-12 Absent 5003 02-Mar-12 Present 5005 02-Mar-12 Leave 5001 04-Mar-12 Present 5003 03-Mar-12 Present 5001 05-Mar-12 Leave 5005 03-Mar-12 Absent 5005 05-Mar-12 Present 5003 05-Mar-12 Present 5005 04-Mar-12 Absent 5002 01-Mar-12 Leave 5002 03-Mar-12 Absent 5002 04-Mar-12 Present 5003 04-Mar-12 Present 5004 01-Mar-12 Present 5004 02-Mar-12 Absent 5004 03-Mar-12 Leave 5004 05-Mar-12 off -----------------------------------
EmpCode Day-1 Day-2 Day-3 Day-4 Day-5 …. Day-30 Preset Absent Leave Off 5001 Present Present Off Present Leave …. Day-30 3 0 1 1 5002 Leave Off Absent Present present …. Day-30 2 1 1 1 5003 Absent Present Present Present present …. Day-30 4 1 5004 Present Absent Leave Leave Off …. Day-30 1 1 2 1 5005 Absent Leave Absent Absent present …. Day-30 1 3 1 ---------------------------------------------------------------------------------------------
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)