Overdue Cases / User true SELECT TOP 100 PERCENT dbo.tbl_Users.UserID, dbo.tbl_Users.FirstName + ' ' + dbo.tbl_Users.LastName AS SystemUser, dbo.tbl_Users.Archived, dbo.tbl_QueueUsers.QueueID, (SELECT COUNT(CallID) FROM tbl_Calls WHERE UserID = tbl_QueueUsers.UserID AND QueueID = [PARAM1] AND CallStatusID IN (1, 2, 4, 5, 7) AND DueDateNotification = 1) AS RecCount 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 System User Overdue Cases SELECT TOP 100 PERCENT tbl_Calls.CallID AS [Case #], 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], tbl_PrimaryKeys.PrimaryKey AS [Category 1], tbl_SecondaryKeys.SecondaryKey AS [Category 2], tbl_TertiaryKeys.TertiaryKey AS [Category 3], tbl_Calls.UserID, tbl_Calls.QueueID, tbl_Calls.Key1, tbl_Calls.Key2, tbl_Calls.Key3, tbl_Calls.CompanyName AS [Primary Company], tbl_Calls.FirstName + ' ' + tbl_Calls.LastName AS [Primary Contact], tbl_Calls.ReqCompanyName AS [Secondary Company], tbl_Calls.ReqFirstName + ' ' + tbl_Calls.ReqLastName AS [Secondary Contact], tbl_Calls.GroupID, tbl_Calls.CallStatusID, tbl_Calls.DateEntered AS [Date Entered], tbl_Calls.DueDate AS [Due Date], tbl_Calls.Closed AS [Closed Date], tbl_Calls.Computer AS [Primary SLA], tbl_Calls.ReqComputer AS [Secondary SLA], tbl_Groups.GroupName, tbl_Billing.NumTransactions, tbl_Billing.ChargeCompany, tbl_Billing.SLA, tbl_Billing.Charge, tbl_Billing.CumulativeTime, tbl_Billing.BilledTo, tbl_Calls.ResUserID FROM tbl_Calls LEFT OUTER JOIN tbl_Users tbl_Users_2 ON tbl_Calls.ResUserID = tbl_Users_2.UserID LEFT OUTER JOIN tbl_Users tbl_Users_1 ON tbl_Calls.UserID = tbl_Users_1.UserID LEFT OUTER JOIN tbl_Billing ON tbl_Calls.CallID = tbl_Billing.CallID LEFT OUTER JOIN tbl_Groups ON tbl_Calls.GroupID = tbl_Groups.GroupID LEFT OUTER JOIN tbl_TertiaryKeys ON tbl_Calls.Key3 = tbl_TertiaryKeys.TertiaryKeyID LEFT OUTER JOIN tbl_SecondaryKeys ON tbl_Calls.Key2 = tbl_SecondaryKeys.SecondaryKeyID LEFT OUTER JOIN tbl_PrimaryKeys ON tbl_Calls.Key1 = tbl_PrimaryKeys.PrimaryKeyID WHERE (tbl_Calls.QueueID = [PARAM1]) AND CallStatusID IN (1, 2, 4, 5, 7) AND DueDateNotification = 1 ORDER BY tbl_Users_1.FirstName + ' ' + tbl_Users_1.LastName, tbl_PrimaryKeys.PrimaryKey, tbl_SecondaryKeys.SecondaryKey, tbl_TertiaryKeys.TertiaryKey