We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Http Post send by Store Procedure Help||5||32|
|SQL Server sp_executesql / Change Tracking Version() results into variable||4||30|
|MS Access Duplicate Data Assistance||9||31|
|SQL Server: Split string value in SELECT query only||5||29|
Join the community of 500,000 technology professionals and ask your questions.