Often I see an OP get "chastised" for not providing enough information
- I'll probably be chastised for providing "too much" information. :-)
Here's a little background
I have a table (computed_visits) that, amonst other columns, has
employee - employee number
sdate - start date
paidt - paid time
For each day of the pay week, an employee will have from 1 to "n" rows
for any given day.
To get the total for an employee for a single day, I can easily
sum(paidt) as paidtime where employee = 1234 and sdate = 'somedate'
To get the week ...