Cases Closed By User For the period: [STARTDATE1] to [ENDDATE1]
true false SELECT dbo.tbl_Users.FirstName + ' ' + dbo.tbl_Users.LastName AS [User], (SELECT COUNT(callid) FROM tbl_calls WHERE dbo.tbl_Calls.UserID = tbl_QueueUsers.UserID AND (dbo.tbl_Calls.QueueID = [PARAM1]) AND (dbo.tbl_Calls.CallStatusID = 3) AND (dbo.tbl_Calls.Closed BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM')) AS TheCount FROM dbo.tbl_Users RIGHT OUTER JOIN dbo.tbl_QueueUsers ON dbo.tbl_Users.UserID = dbo.tbl_QueueUsers.UserID WHERE (dbo.tbl_Users.Archived = 0 OR dbo.tbl_Users.Archived IS NULL) AND (dbo.tbl_QueueUsers.QueueID = [PARAM1]) ORDER BY dbo.tbl_Users.LastName, dbo.tbl_Users.FirstName true User # Cases SELECT TOP 100 PERCENT dbo.tbl_Calls.CallID AS [Case #], dbo.tbl_Calls.Subject, tbl_Users_1.FirstName + ' ' + tbl_Users_1.LastName AS [Assigned To], tbl_Users_2.FirstName + ' ' + tbl_Users_2.LastName AS [Closed By], dbo.tbl_PrimaryKeys.PrimaryKey AS [Category 1], dbo.tbl_SecondaryKeys.SecondaryKey AS [Category 2], dbo.tbl_TertiaryKeys.TertiaryKey AS [Category 3], dbo.tbl_Calls.UserID, dbo.tbl_Calls.QueueID, dbo.tbl_Calls.Key1, dbo.tbl_Calls.Key2, dbo.tbl_Calls.Key3, dbo.tbl_Calls.CompanyName AS [Primary Company], dbo.tbl_Calls.FirstName + ' ' + dbo.tbl_Calls.LastName AS [Primary Contact], dbo.tbl_Calls.ReqCompanyName AS [Secondary Company], dbo.tbl_Calls.ReqFirstName + ' ' + dbo.tbl_Calls.ReqLastName AS [Secondary Contact], dbo.tbl_Calls.GroupID, dbo.tbl_Calls.CallStatusID, dbo.tbl_Calls.DateEntered AS [Date Entered], dbo.tbl_Calls.DueDate AS [Due Date], dbo.tbl_Calls.Closed AS [Closed Date], dbo.tbl_Calls.Computer AS [Primary SLA], dbo.tbl_Calls.ReqComputer AS [Secondary SLA], dbo.tbl_Groups.GroupName, dbo.tbl_Billing.NumTransactions, dbo.tbl_Billing.ChargeCompany, dbo.tbl_Billing.SLA, dbo.tbl_Billing.Charge, dbo.tbl_Billing.CumulativeTime, dbo.tbl_Billing.BilledTo, dbo.tbl_Calls.ResUserID FROM dbo.tbl_Calls LEFT OUTER JOIN dbo.tbl_Users tbl_Users_2 ON dbo.tbl_Calls.ResUserID = tbl_Users_2.UserID LEFT OUTER JOIN dbo.tbl_Users tbl_Users_1 ON dbo.tbl_Calls.UserID = tbl_Users_1.UserID LEFT OUTER JOIN dbo.tbl_Billing ON dbo.tbl_Calls.CallID = dbo.tbl_Billing.CallID LEFT OUTER JOIN dbo.tbl_Groups ON dbo.tbl_Calls.GroupID = dbo.tbl_Groups.GroupID LEFT OUTER JOIN dbo.tbl_TertiaryKeys ON dbo.tbl_Calls.Key3 = dbo.tbl_TertiaryKeys.TertiaryKeyID LEFT OUTER JOIN dbo.tbl_SecondaryKeys ON dbo.tbl_Calls.Key2 = dbo.tbl_SecondaryKeys.SecondaryKeyID LEFT OUTER JOIN dbo.tbl_PrimaryKeys ON dbo.tbl_Calls.Key1 = dbo.tbl_PrimaryKeys.PrimaryKeyID WHERE (dbo.tbl_Calls.QueueID = [PARAM1]) AND (dbo.tbl_Calls.CallStatusID = 3) AND (dbo.tbl_Calls.Closed BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM') ORDER BY tbl_Users_1.FirstName + ' ' + tbl_Users_1.LastName, dbo.tbl_PrimaryKeys.PrimaryKey, dbo.tbl_SecondaryKeys.SecondaryKey, dbo.tbl_TertiaryKeys.TertiaryKey