62 lines
1.6 KiB
Transact-SQL
62 lines
1.6 KiB
Transact-SQL
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
|
|
IF OBJECT_ID('[dbo].[sp_GetTanevKozbenKilepettTanulok]') IS NOT NULL
|
|
BEGIN
|
|
DROP PROCEDURE [dbo].[sp_GetTanevKozbenKilepettTanulok]
|
|
END
|
|
GO
|
|
|
|
-- =============================================
|
|
-- Author: Rudlof Kristóf
|
|
-- Create date: <Create Date,,>
|
|
-- Description: <Description,,>
|
|
-- =============================================
|
|
CREATE PROCEDURE [dbo].[sp_GetTanevKozbenKilepettTanulok]
|
|
@tanevID int
|
|
AS
|
|
BEGIN
|
|
|
|
SELECT
|
|
c_nev OsztalyNev
|
|
FROM T_OSZTALY_OSSZES o
|
|
INNER JOIN T_OSZTALYCSOPORT_OSSZES ocs on ocs.ID=o.ID AND ocs.C_FELADATKATEGORIAID = 7553 /*OktNevelesiKategoriaEnum.Alapkepzes*/
|
|
WHERE o.TOROLT='F' AND o.C_ALTANEVID=@tanevId
|
|
|
|
DECLARE osztalyKurzor CURSOR FOR
|
|
SELECT ID
|
|
FROM T_OSZTALY_OSSZES
|
|
WHERE TOROLT='F'
|
|
AND C_ALTANEVID=@tanevId
|
|
DECLARE @Osztaly int
|
|
|
|
OPEN osztalyKurzor
|
|
FETCH NEXT FROM osztalyKurzor INTO @Osztaly
|
|
WHILE @@FETCH_STATUS = 0
|
|
BEGIN
|
|
SELECT ocs.C_NEV COLUMN379
|
|
, f.C_NYOMTATASINEV COLUMN20
|
|
, FORMAT(tcs.C_BELEPESDATUM, 'yyyy.MM.dd.') COLUMN3784
|
|
, FORMAT(tcs.C_KILEPESDATUM, 'yyyy.MM.dd.') COLUMN1
|
|
,tcs.C_ZARADEK COLUMN1557
|
|
FROM T_TANULOCSOPORT_OSSZES tcs
|
|
INNER JOIN T_OSZTALY_OSSZES o on tcs.C_OSZTALYCSOPORTID=o.ID
|
|
INNER JOIN T_OSZTALYCSOPORT_OSSZES ocs on o.ID=ocs.ID
|
|
INNER JOIN T_FELHASZNALO_OSSZES f on f.ID=tcs.C_TANULOID
|
|
WHERE
|
|
tcs.C_KILEPESDATUM IS NOT NULL
|
|
and tcs.C_TANEVID=@tanevId
|
|
and o.ID=@Osztaly
|
|
and tcs.TOROLT='F'
|
|
ORDER BY f.C_NYOMTATASINEV
|
|
FETCH NEXT FROM osztalyKurzor INTO @Osztaly
|
|
END
|
|
CLOSE osztalyKurzor
|
|
DEALLOCATE osztalyKurzor
|
|
|
|
END
|
|
|
|
GO |