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 ClientID, Cltname, Cltnum, CltEng, Status, LastInvoiceDate, CurrentDate, NumberOfDays, CBMnum FROM (SELECT a.ClientID, c.Cltname, c.Cltnum, c.CltEng, c.Engstatus AS Status, MAX(a.InvoiceDate) AS LastInvoiceDate, GETDATE() AS CurrentDate, DATEDIFF(day, MAX(a.InvoiceDate), GETDATE()) AS NumberOfDays, c.CBMnum FROM ARC_Invoices AS a LEFT OUTER JOIN Clients AS c ON a.ClientID = c.ID WHERE (c.Engstatus = 0) GROUP BY a.ClientID, c.Engstatus, c.Cltname, c.Cltnum, c.CltEng, c.CBMnum) AS a_1 WHERE (NumberOfDays > 45) ORDER BY ClientID, LastInvoiceDate DESC
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
28 Experts available now in Live!