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
Ashutosh Jha
NA
3
831
Need the in & out time with total working hours
May 5 2016 3:48 PM
Need one help. I have some record like below for around 100 members on daily basis-
Date & Time Reader User ID
3/14/2016 6:00 AM In 123
3/14/2016 7:00 AM out 123
3/14/2016 8:00 AM In 123
3/14/2016 9:00 AM out 123
3/15/2016 10:00 AM In 123
3/15/2016 11:00 AM out 123
3/15/2016 12:00 PM In 123
3/15/2016 1:00 PM out 123
3/16/2016 2:00 PM In 123
3/16/2016 3:00 PM out 123
Data is in Excel but can be put in SQL. Can somebody tell me how I can find the first In time, Last out time and the time person was In on daily basis.
Any help will be appreciated.
Reply
Answers (
2
)
Dependent nested sp's
How to open external exe file from SQL Query