Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.
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
|Analysis of table use||7||30|
|Microsoft Access Can't Resolve Dates in SQL Server 2012 Tables||6||93|
|How to find all values in a column which is not money||25||27|
|SQL index creation taking an abnormally long time||2||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!