PLEASE HELP ME FRIENDS -- IT IS VERY URGENT.
I have to make an employee attendance sheet in which i have to display only those employees which are present for 9 or more than 9 days continuously. Also here continuous means all those days on which employee is present regardless of that day, i.e whether the day is a holiday or public holiday if employee is present and it is coming in the continuous 10 days chunk then it should be displayed. Now the problem is that i am able to get the maximum working days for each employee as well as the dates from which his/her 10 date continuously present started and the date at which it ended. Now the only problem that i am getting is that i have placed all this information in detail section, and the problem starts here that all the employee records which are coming 10 or more days appears with an unusual format e.gEmpId EmpName WorkingDays DateFrom DateTo34 Hassan Ali 10 8/22/2008 8/31/200835 Muhammad Khalil 10 8/1/2008 8/10/200835 Muhammad Khalil 11 8/1/2008 8/11/200835 Muhammad Khalil 12 8/1/2008 8/12/200835 Muhammad Khalil 10 8/18/2008 8/27/200835 Muhammad Khalil 11 8/18/2008 8/28/200835 Muhammad Khalil 12 8/18/2008 8/29/200835 Muhammad Khalil 13 8/18/2008 8/30/200835 Muhammad Khalil 14 8/18/2008 8/31/2008now i only want to retrieve the maximum of these working days for each employee id i.e only the following record should be displayedEmpId EmpName WorkingDays DateFrom DateTo
34 Hassan Ali 10 8/22/2008 8/31/200835 Muhammad Khalil 12 8/1/2008 8/12/200835 Muhammad Khalil 14 8/18/2008 8/31/2008Please help me as it is urgent, because it is an assignment given to me by my boss and already the task has gone into a long delay. Please help me
URGENT PLEASE HELP ME FRIENDS -- IT IS VERY URGENT AND IMPORTANT.
|