Overdue Calls - No Response To Requestor true SELECT dbo.tbl_Calls.CallID, dbo.tbl_Calls.Subject, dbo.tbl_Users.FirstName + ' ' + dbo.tbl_Users.LastName FROM dbo.tbl_Calls LEFT OUTER JOIN dbo.tbl_Users ON dbo.tbl_Calls.UserID = dbo.tbl_Users.UserID WHERE ((dbo.tbl_Calls.QueueID = [PARAM1]) AND (dbo.tbl_Calls.CallStatusID IN (1, 2, 4, 5, 7)) AND DATEDIFF(ss, tbl_Calls.DueDate, GETDATE()) >= 0 AND ((SELECT COUNT(CallID) FROM tbl_CallAudit WHERE CallID = tbl_Calls.CallID AND ActionID = 15) = 0)) ORDER BY tbl_Calls.CallID DESC Call # Problem Owner