% Of Cases Closed By Due Date For Customer For the period: [STARTDATE1] to [ENDDATE1]
true false SELECT DISTINCT TOP 100 PERCENT CompanyName, COUNT(CallID) AS TotalCasesLogged, (SELECT COUNT(callid) FROM tbl_calls WHERE datediff(ss, Closed, DueDate) >= 0 AND (CompanyName = Table1.CompanyName) AND (QueueID = [PARAM1]) AND (DateEntered BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM')) AS [Num Closed Within Due Date] FROM dbo.tbl_Calls Table1 WHERE (QueueID = [PARAM1]) AND (DateEntered BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM') GROUP BY CompanyName ORDER BY CompanyName true Customer Total Cases Logged # Cases Closed On Or Before Due Date