IF OBJECT_ID('dbo.fnGetOsztalyVegzosTanitasiNap') IS NOT NULL BEGIN
  DROP FUNCTION dbo.fnGetOsztalyVegzosTanitasiNap
END
GO

CREATE FUNCTION dbo.fnGetOsztalyVegzosTanitasiNap (@osztalyId INT, @intezmenyId INT, @tanevId INT)
  RETURNS datetime
BEGIN

	DECLARE @Global DATETIME = (SELECT C_DATUM FROM T_TANEVRENDJE where C_NAPTIPUSA = 1402 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevId);
	DECLARE @result DATETIME = @Global;
	DECLARE @isVegzos CHAR(1) = (SELECT C_VEGZOSEVFOLYAM FROM T_OSZTALYCSOPORT WHERE ID = @osztalyId AND TOROLT = 'F');

	IF(@isVegzos = 'T')
	BEGIN
		SET @result =
		(SELECT TOP(1) C_DATUM FROM (
			SELECT C_DATUM FROM T_TANEVRENDJE tr
				LEFT JOIN T_OSZTALYCSOPORT_TANEVRENDJE otr ON tr.ID = otr.C_TANEVRENDJEID AND otr.C_OSZTALYCSOPORTID = @osztalyId
			WHERE
				C_NAPTIPUSA IN (7600,7601,7602,7603) AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevId AND tr.TOROLT = 'F'
		) x ORDER BY C_DATUM)
	END
	RETURN ISNULL(@result, @Global)

END;
GO