| Author |
 Topic  |
|
|
dougancil
Posting Yak Master
USA
217 Posts |
 Posted - 11/12/2010 : 13:51:54
|
I am using this query to sum payroll for a time period, but I'd also like to do it per day:
select name, employeenumber, (cast (sum (ontime) as decimal (10,2))) as minutes into scratchpad2
from scratchpad1
where date between '10/1/2010' and '10/15/2010'
group by employeenumber, name
order by employeenumber asc
Would I just use distinct here? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
madhivanan
Premature Yak Congratulator
India
22460 Posts |
Posted - 11/15/2010 : 05:47:02
|
select name, employeenumber, dateadd(day,datediff(day,0,date),0) as dateonly,(cast (sum (ontime) as decimal (10,2))) as minutes into scratchpad2
from scratchpad1
where date between '10/1/2010' and '10/15/2010'
group by employeenumber, name ,dateadd(day,datediff(day,0,date),0)
order by employeenumber asc
Madhivanan
Failing to plan is Planning to fail |
 |
|
|
dougancil
Posting Yak Master
USA
217 Posts |
Posted - 11/15/2010 : 10:04:43
|
Madhivanan,
Thank you. That works perfectly.
Doug |
|
|
|
madhivanan
Premature Yak Congratulator
India
22460 Posts |
Posted - 11/16/2010 : 03:02:56
|
quote:
Originally posted by dougancil
Madhivanan,
Thank you. That works perfectly.
Doug
You are welcome 
Madhivanan
Failing to plan is Planning to fail |
|
|
| |
Topic |
|
Summing per day rather than per period
