Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
select Base.CASENO as [Matter Number], INVOICES.INV_NO as [Invoice Number], sum(INVTRANS.TRANS_AMT) as [Total Fees], ISNULL(INVTRANS.TRANS_HOURS, '') as [Units], CASE WHEN INVTRANS.TRANS_HOURS IS NULL THEN 0 WHEN INVTRANS.TRANS_HOURS = 0 THEN 0 ELSE INVTRANS.TRANS_AMT/INVTRANS.TRANS_HOURS END as [Rate], INVTRANS.TRANS_AMT as [Item Total], INVTRANS.INVTRANS_ID from INVTRANS inner join INVOICES on INVTRANS.INVOICE_ID = INVOICES.INVOICE_ID left outer join BASE on INVTRANS.MATTER_ID = BASE.MATTER_ID group by base.CASENO, invoices.INV_NO, INVTRANS.TRANS_HOURS, INVTRANS.TRANS_AMT, INVTRANS.INVTRANS_ID order by 2, 1
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.