how to use pivot for this task

Question

i have a table like below attdate intime outtime 03-01-17 08:45 18:00 03-02-17 08:45 20:00 my expected result is 1 2 3 p p ab

siva nathan · Answer

hii Amit first of all my requirement is i want to show employee monthly attendence report like presentabsentweekholidaynational holiday my table record is like below empid empname attdate intime outtime 1 a 03-01-17 08:00 18:00 2 b 03-01-17 08:00 18:00 1 a 03-02-17 08:10 18:10 my expected result is empid empname 1 2 3 1 a p p ab 2 b p ab ab if the time difference between outtime and intime is >=8 means present if at that day absent means put ab if at that day is sunday means put wh

Amit Gupta · Answer

Your question was not clear. Please elaborate what exactly the requirement is?