Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
msb
Starting Member
1 Post |
 Posted - 2008-11-05 : 05:46:52
|
| I have a query where I have a date column (which tells about "IN" & "OUT" timing of the people attendance)from H table,Ename from C table.The date row sample is 2007-10-24 15:27:10.000 & datatype is date My queries are :-1) How to get the daily attendance of each employee 2) How to come to know if the employee is present less than 5 hoursPlease let me know the query for it? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-05 : 06:25:11
|
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
How to split date column & sum it up