38 lines
3.5 KiB
Transact-SQL
38 lines
3.5 KiB
Transact-SQL
DECLARE intezmenytanevekCursor CURSOR LOCAL FOR
|
|
SELECT
|
|
ia.C_INTEZMENYID
|
|
,ia.C_TANEVID
|
|
FROM T_INTEZMENYADATOK ia
|
|
JOIN T_TANEV t ON t.ID = ia.C_TANEVID AND t.TOROLT = 'F'
|
|
JOIN T_INTEZMENY i ON i.ID = ia.C_INTEZMENYID AND i.TOROLT = 'F'
|
|
WHERE ia.TOROLT = 'F'
|
|
DECLARE @intezmenyId int, @tanevId int
|
|
|
|
OPEN intezmenytanevekCursor
|
|
FETCH NEXT FROM intezmenytanevekCursor INTO @intezmenyId, @tanevId
|
|
WHILE @@FETCH_STATUS = 0
|
|
BEGIN
|
|
IF (SELECT COUNT(1) FROM T_TANEVRENDJE_OSSZES WHERE C_INTEZMENYID = @intezmenyID AND C_TANEVID = @tanevID AND TOROLT = 'F') > 1
|
|
BEGIN
|
|
IF (EXISTS(SELECT ID FROM T_INTEZMENYADATOK_OSSZES WHERE C_INTEZMENYID = @intezmenyId AND C_ISSZAKKEPZO = 'T' AND TOROLT = 'F' AND C_TANEVID = @tanevID)
|
|
AND EXISTS(SELECT ID FROM T_TANEV_OSSZES WHERE TOROLT = 'F' AND C_SORSZAM > 40 AND ID = @tanevID))
|
|
BEGIN
|
|
UPDATE T_DICTIONARYITEMBASE_OSSZES SET C_NAME = N'Nappali rendszerű iskolai oktatás' WHERE ID = 1096 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevID AND C_DICTIONARYTYPEID = 27
|
|
UPDATE T_DICTIONARYITEMBASE_OSSZES SET C_VISIBLE = 'F' WHERE ID = 1097 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevID AND C_DICTIONARYTYPEID = 27
|
|
UPDATE T_DICTIONARYITEMBASE_OSSZES SET C_NAME = N'Kollégiumi nevelés' WHERE ID = 1099 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevID AND C_DICTIONARYTYPEID = 27
|
|
UPDATE T_DICTIONARYITEMBASE_OSSZES SET C_VISIBLE = 'F' WHERE ID = 1103 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevID AND C_DICTIONARYTYPEID = 27
|
|
UPDATE T_DICTIONARYITEMBASE_OSSZES SET C_VISIBLE = 'F' WHERE ID = 1101 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevID AND C_DICTIONARYTYPEID = 27
|
|
UPDATE T_DICTIONARYITEMBASE_OSSZES SET C_VISIBLE = 'F' WHERE ID = 1102 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevID AND C_DICTIONARYTYPEID = 27
|
|
UPDATE T_DICTIONARYITEMBASE_OSSZES SET C_VISIBLE = 'F' WHERE ID = 1104 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevID AND C_DICTIONARYTYPEID = 27
|
|
UPDATE T_DICTIONARYITEMBASE_OSSZES SET C_VISIBLE = 'F' WHERE ID = 5448 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevID AND C_DICTIONARYTYPEID = 27
|
|
UPDATE T_DICTIONARYITEMBASE_OSSZES SET C_VISIBLE = 'F' WHERE ID = 1100 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevID AND C_DICTIONARYTYPEID = 27
|
|
UPDATE T_DICTIONARYITEMBASE_OSSZES SET C_VISIBLE = 'F' WHERE ID = 1105 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevID AND C_DICTIONARYTYPEID = 27
|
|
UPDATE T_DICTIONARYITEMBASE_OSSZES SET C_NAME = N'Felnőttoktatás esti rendszerű OKJ vagy köznevelés',C_NAME_1 = N'Felnőttoktatás esti rendszerű OKJ vagy köznevelés' WHERE ID = 5446 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevID AND C_DICTIONARYTYPEID = 27
|
|
UPDATE T_DICTIONARYITEMBASE_OSSZES SET C_NAME = N'Felnőttoktatás levelező rendszerű OKJ vagy köznevelés',C_NAME_1 = N'Felnőttoktatás levelező rendszerű OKJ vagy köznevelés' WHERE ID = 5447 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevID AND C_DICTIONARYTYPEID = 27
|
|
UPDATE T_DICTIONARYITEMBASE_OSSZES SET C_NAME = N'Felnőttoktatás nappali rendszerű OKJ vagy köznevelés',C_NAME_1 = N'Felnőttoktatás nappali rendszerű OKJ vagy köznevelés' WHERE ID = 5445 AND C_INTEZMENYID = @intezmenyId AND C_TANEVID = @tanevID AND C_DICTIONARYTYPEID = 27
|
|
END
|
|
END
|
|
FETCH NEXT FROM intezmenytanevekCursor INTO @intezmenyId, @tanevId
|
|
END
|
|
CLOSE intezmenytanevekCursor
|
|
DEALLOCATE intezmenytanevekCursor
|