Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
select mmatter, mdesc1, tklast + ', ' + tkfirst + ' (' + tkinit + ')' as WA, sum(hwacur) as MTD_Billable_hours, sum(hwaytd) as YTD_Billable_hours from df_dwtkmat , df_dwcontrol, matter, timekeep where matter in (select distinct mmatter from timecard where ttk='02500' and tworkdt between getdate()-30 and getdate()) and rectype=4020 and defvalue=pe and matter=mmatter and watty=tkinit group by mmatter, mdesc1, tklast + ', ' + tkfirst + ' (' + tkinit + ')' having sum(hwacur) <> 0 or sum(hwaytd)<> 0 order by mmatter, mdesc1, tklast + ', ' + tkfirst + ' (' + tkinit + ')'
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!