SQL Server - Ayuda con Count

Buenas Tardes, estoy realizando una sentencia en la cual necesito sacar todas las veces que cierto empleado no marco durante cierto periodo pero la sentencia me envia una cantidad muy grande de registros "SIN MARCA" y no me los agrupa por usuario. Esta es la sentencia
SELECT
Employee.EmployeeId,
Employee.EmployeeFirstName,
Employee.EmployeeLastName,
Employee.EmployeeArea,
EmployeeAccess.EmployeeInTime,
EmployeeAccess.EmployeeOutTime,
EmployeeAccess.EmployeeLabTime,
EmployeeAccess.EmployeeLabDay,
EmployeeAccess.EmployeeJustification,
(
SELECT count (EmployeeAccess.EmployeeOutTime)
FROM EmployeeAccess
WHERE (EmployeeAccess.EmployeeInTime=Cast(N'00:00:00' as nvarchar(9)) and (EmployeeAccess.EmployeeOutTime=Cast (N'00:00:00' as nvarchar(9))))
--group by Employee.EmployeeId
) AS SinMarca

FROM
Employee INNER JOIN
EmployeeAccess ON Employee.EmployeeId = EmployeeAccess.EmployeeId


WHERE (EmployeeAccess.EmployeeJustification IS NULL)
and (Employee.EmployeeArea<>'Soporte Tecnologico')
and (Employee.EmployeeArea<>'Division Gestion de Red y Mantenimiento')
and (Employee.EmployeeArea<>'Continuidad Operativa del Negocio')

group by Employee.EmployeeId,
Employee.EmployeeFirstName,
Employee.EmployeeLastName,
Employee.EmployeeArea,
EmployeeAccess.EmployeeInTime,
EmployeeAccess.EmployeeOutTime,
EmployeeAccess.EmployeeLabTime,
EmployeeAccess.EmployeeLabDay,
EmployeeAccess.EmployeeJustification
order by SinMarca

¿Esto te da algun resultado?

SELECT count (EmployeeAccess.EmployeeOutTime)
FROM EmployeeAccess
WHERE (EmployeeAccess.EmployeeInTime=Cast(N'00:00:00' as nvarchar(9)) and (EmployeeAccess.EmployeeOutTime=Cast (N'00:00:00' as nvarchar(9))))

No creas que el motor de base de datos se le da muy bien la ADIVINANZA, debes tener una tabla, donde estan marcados claramente tus horarios y de ahi, basarte para aquellos que no tienen marca.