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 D.DebtorID, DS.ServiceID, cast(Payments as money) - IsNull(LastPayment,0) as Payment, cast(Adjustments as money) - IsNull(LastAdjustment,0) as Adjustment, 'File Balance <> Service Balance' as Reason, cast(Payments as money), cast(Adjustments as money), LastPayment, LastAdjustment from Strat_Customers.dbo.Customer_CareInvoice IL inner join DebtorService DS on IL.InvoiceNumber = DS.InvoiceNo inner join DebtorInvoice DI on DS.ServiceID = DI.ServiceID inner join Debtor D on DS.DebtorID = D.DebtorID where D.OrgID in (select distinct(I.OrgID) from Strat_Customers.dbo.Customer_CareInvoice I) --Change for new customer and cast(IL.InvoiceBalance as money) <> BalanceDue and D.StatusID in (1,2,6,8,9,10,12,20,19) --New, Suspended, Bad Address, Letters Complete, Letter Series, Payment Plan, Payment Late, Payment Breach, Invoice
|Need an intro to -- .Net SQL Authorization Manager||7||47|
|Classic ASP application Will support SQL 2014||5||30|
|Updating ms sql with special characters||8||19|
|How can I use one field instead of another in an SQL query when conditions apply||12||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!