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 |
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
 Posted - 2003-05-01 : 15:32:05
|
| SELECT SUM(Hours) AS SUMHOURSFROM TimeCardItemsWHERE (WeekEndingDate - 6 + DayID BETWEEN '1/1/2002' AND '1/1/2003') AND (EmployeeID = '36860') |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-01 : 15:38:39
|
| SELECT SUM(Hours) AS Expr1, WeekEndingDateFROM TimeCardItemsWHERE (WeekEndingDate - 6 + DayID BETWEEN '1/1/2002' AND '1/1/2003') AND (EmployeeID = '36860')GROUP BY WeekEndingDate |
 |
|
|
|
|
|
For Iancu