DROP PROCEDURE IF EXISTS uspIsLeader
GO

CREATE PROCEDURE uspIsLeader
   @pAlkalmazottId INT
  ,@pTanevId INT
AS
BEGIN
  SET NOCOUNT ON;

  SELECT ma.C_VEZETOIORASZAMOK
  FROM T_MUNKAUGYIADATOK_OSSZES ma
  WHERE ma.C_ALKALMAZOTTID = @pAlkalmazottId
    AND ma.TOROLT = 'F'
    AND ma.C_TANEVID = @pTanevId
END
GO