View: dbo.Client_Active_Employees_View
View definition
CREATE VIEW dbo.Client_Active_Employees_View
AS
SELECT client_KEY
,count(*) as number_of_employees
FROM dbo.Employee_View
WHERE active_status_KEY = 1
GROUP BY client_KEY