hi - i have the below query that inserts the manager name once and the count of how many records are assigned to that manager with an EmpConsultantIndicator value that = e
SELECT DISTINCT CopyMasterResource.Manager, Count(CopyMasterResource.EmpConsultantIndicator) AS [FTE Count] INTO...