Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
5
Answers
how to get total working hours per day?
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Mani Kandan
8y
339
1
Reply
Hello Everyone,
how to get total working hours per day with respect to a HolderName using sql query?
This is the sql table that contain input/output date and time with input/output status.
Kindly answer me.
Thanks advance.
ID
CardNo
HolderNo
HolderName
IODate
IOTime
IOGateNo
IOGateName
IOStatus
1
118
85
Raj
1/1/2016
12:14PM
1-Jan
Door #1(I/O)
Entry
2
118
85
Raj
1/1/2016
12:14PM
2-Jan
Door #2(I/O)
Entry
3
118
85
Raj
1/1/2016
12:14PM
6-Jan
Door #2(I/O)
Exit
4
118
85
Raj
1/1/2016
12:15PM
2-Jan
Door #2(I/O)
Entry
5
118
85
Raj
1/1/2016
4:05PM
6-Jan
Door #2(I/O)
Exit
6
118
85
Raj
1/1/2016
4:05PM
5-Jan
Door #1(I/O)
Exit
7
118
85
Raj
1/1/2016
4:08PM
1-Jan
Door #1(I/O)
Entry
8
118
85
Raj
1/1/2016
4:08PM
2-Jan
Door #2(I/O)
Entry
9
118
85
Raj
1/1/2016
4:09PM
6-Jan
Door #2(I/O)
Exit
10
118
85
Raj
1/1/2016
4:09PM
5-Jan
Door #1(I/O)
Exit
Post
Reset
Cancel
Answers (
5
)
Next Recommended Forum
My question is regarding Asp.net C # and Sql server 2008
database usin dapper