ganapathy.arvindan (5/30/2016)
IT IS WORKING FINE BUT IN THE OUTPUT I ALSO NEED THE DETAILS OF D1..D31 SHIFTS AND FINALLY THE WORKING DAYSLIKE THIS
empid D1 D2.............D31 working days
290 dayshift dayshift........Nightshift 22
join your employee table to the results from the code I gave you.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day