Displaying 1 result from an estimated 1 matches for "chargehours".
2006 Mar 28
2
Fastest way of adding " " around multiline text in RADRAILS
...d of each line. It is very tedious. What is the best method?
select timesheets.employee,
sum(items.hours) as hours,
sum(items.hours*timesheets.cost)
as cost,
sum(items.hours*timesheets.charge*decode(activities.chargetype,0,1,0))
as charge,
sum(items.hours*decode(activities.chargetype,0,1,0)) as chargehours
from timesheets, contacts, items, activities, employees, divisions
where
contacts.com_branch_id = 241 and
employees.contact_id = contacts.CONTACT_ID and
contacts.expired=0 and
timesheets.id = items.timesheet and
activities.id = items.activity and employees.id=timesheets.employee and
divisions.id=e...