DROP PROCEDURE  IF EXISTS uspGetAktivTanevKezdete 
GO

CREATE PROCEDURE uspGetAktivTanevKezdete
   @pIntezmenyId INT
AS
BEGIN
  SET NOCOUNT ON;

  SELECT C_ELSOTANITASINAP AS ElsoTanitasiNap
  FROM T_TANEV_OSSZES Tanev
  WHERE Tanev.TOROLT = 'F'
    AND Tanev.C_AKTIV = 'T'
    AND Tanev.C_INTEZMENYID = @pIntezmenyId
END
GO