TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Rajeev Jha
NA
1
1.5k
Pivot Table in SQL
Jan 7 2013 9:17 AM
Hi,
please view the sample data:
EmpCode
Att_Date
Duration_HR
Duration_Mn
Remarks
NoOfLeaves
750
10/01/2012
9
25
Null
0
751
10/01/2012
8
50
Late
0
752
10/01/2012
9
8
A
0
750
10/02/2012
10
2
Null
0
752
10/02/2012
8
0
Late
0
753
10/02/2012
Null
Null
Null
1
I want to have this data in following
10/01/2012
10/02/2013
750
750
9:25
10:02
Null
Null
0
0
751
752
8:50
8:00
Late
Late
0
0
752
753
9:08
Null
A
Null
0
Null
I am trying to go with Pivot, but not able to get the perfect output. I will get the date range and EmpCode at runtime(from user).
Reply
Answers (
1
)
Finding 2nd and 4th saturdays and sundays in SQL proc or JS
sql 2008