Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
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
|need help in sql||4||65|
|why does some in the xx field return as null? Case statement||2||21|
|Can someone plz fix this..getting an error||3||18|
|Adding Subtracting values in sql server||5||19|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!