21 lines
769 B
Transact-SQL
21 lines
769 B
Transact-SQL
DROP PROCEDURE IF EXISTS [dbo].[sp_GetFelhasznaloErintettOsztalyai]
|
|
GO
|
|
|
|
CREATE PROCEDURE [dbo].[sp_GetFelhasznaloErintettOsztalyai]
|
|
@felhasznaloId INT
|
|
,@feladatellatasihelyId INT = NULL
|
|
AS
|
|
BEGIN
|
|
SELECT
|
|
ocs.ID as ID
|
|
,ocs.C_NEV as Nev
|
|
,'1' as Tipus
|
|
,cs.C_TIPUSA as CsoportTipusa
|
|
,ocs.C_EVFOLYAMTIPUSA as Evfolyam
|
|
FROM T_OSZTALYCSOPORT ocs
|
|
LEFT JOIN T_OSZTALY o ON o.ID=ocs.ID AND (o.C_OSZTALYFONOKID=@felhasznaloId OR o.C_OFOHELYETTESID = @felhasznaloId)
|
|
LEFT JOIN T_CSOPORT cs ON cs.ID=ocs.ID AND cs.C_CSOPORTVEZETOID=@felhasznaloId
|
|
WHERE ocs.TOROLT = 'F' AND (@feladatellatasihelyId IS NULL OR ocs.C_FELADATELLATASIHELYID=@feladatellatasihelyId)
|
|
AND NOT (o.ID IS NULL AND cs.ID IS NULL)
|
|
ORDER BY cs.C_TIPUSA, ocs.C_EVFOLYAMTIPUSA
|
|
END |