CREATE PROC usp_AssignProject
	@emloyeeId INT,
	@projectID INT
AS
BEGIN
	DECLARE @countEmplyeeProjects INT
	SET @countEmplyeeProjects = (SELECT COUNT(ep.ProjectID)
			   FROM EmployeesProjects ep
			   WHERE ep.EmployeeID = @emloyeeId
			   GROUP BY ep.EmployeeID);
	IF (@countEmplyeeProjects > 3)
	BEGIN
		THROW 50001, 'The employee has too many projects!', 1;
	END
	INSERT INTO EmployeesProjects(EmployeeID, ProjectID)
	VALUES (@emloyeeId, @projectID)
END