SELECT count(*) c
FROM #Request.prefix_db_agency#.Communication ,#Request.prefix_db_agency#.communication_to ct
WHERE Communication.Agency_ID = '#session.AgencyID#'
AND Communication.Resolved = 'No'
AND ct.comm_id = Communication.Comm_ID
AND ct.employee_id = '#session.EmployeeId#'
SELECT count(*) c
FROM #Request.prefix_db_agency#.Communication
WHERE Communication.Agency_ID = '#session.AgencyID#'
AND Communication.Record_Created_By = '#session.EmployeeId#'
AND Communication.Resolved = 'No'
SELECT count(*) c
FROM #Request.prefix_db_agency#.Communication,#Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.CommunicationSubjects
WHERE Communication.Agency_ID = '#session.AgencyID#'
AND Communication.Resolved = 'No'
AND Employee.Employee_ID = Communication.Employee_ID
AND patient.Patient_ID = Communication.Patient_ID
AND CommunicationSubjects.CommSub_ID = Communication.CommSub_ID
0 incidents