Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Answer
how to use pivot in sql
siva nathan
7y
151
1
Reply
i have a table record like this
empid
empname
attdate
intime
outtime
1
a
03-01-17
08:45
18:00
1
a
03-02-17
08:40
18:10
2
b
03-01-17
08:47
18:10
3
c
03-01-17
08:50
18:05
my expected result is for a month
empid
empname
day 1
day 2
day 3
1
a
p
p
a
2
b
p
a
a
3
c
p
a
a
4
d
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
counting Textbox Control
Windows Application using c# Code