Loading

how to use pivot for this task

siva nathan

i have a table like below

my expected result is

1	2	3
p	p	ab

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

siva nathan9y ago
hii Amit,
first of all my requirement is i want to show employee monthly attendence report like present,absent,weekholiday,national 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
0
Amit Gupta9y ago
Your question was not clear. Please elaborate, what exactly the requirement is?
0