30 lines
812 B
Transact-SQL
30 lines
812 B
Transact-SQL
DROP PROCEDURE IF EXISTS uspGetTanevRendjeData
|
|
GO
|
|
|
|
CREATE PROCEDURE uspGetTanevRendjeData
|
|
@pTanevId int
|
|
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT
|
|
tr.ID AS Id
|
|
,tr.C_DATUM AS Datum
|
|
,tr.C_HETNAPJA AS NapId
|
|
,tr.C_NAPTIPUSA AS NapTipusId
|
|
,tr.C_HETIREND AS HetirendId
|
|
,tr.C_MEGJEGYZES AS Megjegyzes
|
|
,(SELECT count(1) FROM T_OSZTALYCSOPORT_TANEVRENDJE WHERE T_OSZTALYCSOPORT_TANEVRENDJE.C_TANEVRENDJEID = tr.ID) VonatkozoOsztalyCsoportSzam
|
|
,tr.C_OSSZESCSOPORTRAVONATKOZIK AS IsOsszesCsoportraVonatkozik
|
|
,tr.C_ISURESORAREND AS IsUresOrarend
|
|
,tr.C_ORARENDINAP AS IsOrarendiNap
|
|
,tv.C_NEV AS TanevNev
|
|
FROM T_TANEVRENDJE_OSSZES tr
|
|
INNER JOIN T_TANEV_OSSZES tv ON tv.ID = tr.C_TANEVID AND tv.TOROLT = 'F'
|
|
WHERE tr.C_TANEVID = @ptanevId
|
|
AND tr.TOROLT = 'F'
|
|
END
|
|
|
|
GO
|
|
|