We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.
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 a step to a system backup job||6||19|
|Location of Dynamics AX Service accounts in SQL||3||16|
|Using T-SQL (SQL Server 2008 R2) to determine whether file exist on server and delete it||4||31|
|MS SQL query to show nearest date||6||39|