23 lines
560 B
Transact-SQL
23 lines
560 B
Transact-SQL
DROP FUNCTION IF EXISTS fnGetTanuloAktualisOsztaly
|
|
GO
|
|
|
|
CREATE FUNCTION fnGetTanuloAktualisOsztaly (@tanuloId int)
|
|
RETURNS nvarchar (255)
|
|
BEGIN
|
|
DECLARE @value nvarchar (255)
|
|
|
|
SELECT TOP (1)
|
|
@value = ocs.C_NEV
|
|
FROM T_TANULOCSOPORT_OSSZES tcs
|
|
INNER JOIN T_OSZTALY_OSSZES o ON tcs.C_OSZTALYCSOPORTID = o.ID AND o.TOROLT = 'F'
|
|
INNER JOIN T_OSZTALYCSOPORT_OSSZES ocs ON ocs.ID = o.ID AND ocs.TOROLT = 'F'
|
|
WHERE C_TANULOID = @tanuloId
|
|
AND tcs.TOROLT = 'F'
|
|
AND C_KILEPESDATUM IS NULL
|
|
ORDER BY C_KILEPESDATUM
|
|
|
|
RETURN @value
|
|
|
|
END
|
|
GO
|