44 lines
974 B
Transact-SQL
44 lines
974 B
Transact-SQL
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
IF OBJECT_ID('sp_GetOsztalyokEvesOraszama') IS NOT NULL BEGIN
|
|
DROP PROCEDURE sp_GetOsztalyokEvesOraszama
|
|
END
|
|
GO
|
|
|
|
CREATE PROCEDURE sp_GetOsztalyokEvesOraszama
|
|
@tanevID int
|
|
AS
|
|
BEGIN
|
|
|
|
SELECT OsztalyNev Nev FROM fnGetDokumentumOsztalyokTanevenkent(@tanevID)
|
|
|
|
DECLARE kurzor CURSOR FOR
|
|
SELECT OsztalyId FROM fnGetDokumentumOsztalyokTanevenkent(@tanevID)
|
|
|
|
DECLARE @OsztalyId int
|
|
|
|
OPEN kurzor
|
|
FETCH NEXT FROM kurzor INTO @OsztalyId
|
|
|
|
WHILE @@FETCH_STATUS = 0 BEGIN
|
|
SELECT distinct
|
|
tanulo.C_NYOMTATASINEV TanuloNev
|
|
, tantargy.C_NEV TantargyNev
|
|
, oraszamok.Oraszam EvesOraszam
|
|
FROM
|
|
fnGetDokumentumTanulokEvesOraszamaiOsztalynkonet(@tanevID, @OsztalyId) oraszamok
|
|
INNER JOIN T_FELHASZNALO_OSSZES tanulo on tanulo.ID = oraszamok.TanuloId
|
|
INNER JOIN T_TANTARGY_OSSZES tantargy on tantargy.ID = oraszamok.TantargyID
|
|
|
|
FETCH NEXT FROM kurzor INTO @OsztalyId
|
|
END
|
|
|
|
CLOSE kurzor
|
|
DEALLOCATE kurzor
|
|
|
|
END
|
|
|
|
GO |