30 lines
2.0 KiB
SQL
30 lines
2.0 KiB
SQL
UPDATE tgy
|
|
SET C_ESLTANTARGYKATEGORIAID =
|
|
CASE
|
|
WHEN C_TARGYKATEGORIA IN (1202,6726,6737) THEN 7578 --ANGOL
|
|
WHEN C_TARGYKATEGORIA IN (1203,6731,6741) THEN 7579 --NÉMET
|
|
WHEN C_TARGYKATEGORIA IN (1204,6729,6739) THEN 7580 --FRANCIA
|
|
WHEN C_TARGYKATEGORIA IN (1205,1206,1207,1208,1209,6728,6729,6730,6731,6732,6733,6734,6738,6739,6740,6741,6742,6743,6744) THEN 7581 --EGYÉB NYELV
|
|
WHEN C_TARGYKATEGORIA IN (1200) THEN 7582 --NEMZETISÉGI
|
|
WHEN C_TARGYKATEGORIA IN (1210) THEN 7583 --MATEK
|
|
WHEN C_TARGYKATEGORIA IN (1198) AND tgy.C_NEV LIKE '%irodalom%' THEN 7585 --MAGYAR NYELV ÉS IRODALOM (IRODALOM)
|
|
WHEN C_TARGYKATEGORIA IN (1198) AND tgy.C_NEV LIKE '%nyelv%' THEN 7584 --MAGYAR NYELV ÉS IRODALOM (NYELV(TAN))
|
|
WHEN C_TARGYKATEGORIA IN (1219) THEN 7588 --FIZIKA
|
|
WHEN C_TARGYKATEGORIA IN (1220) THEN 7589 --KÉMIA
|
|
WHEN C_TARGYKATEGORIA IN (1221) THEN 7590 --BIOLÓGIA
|
|
WHEN C_TARGYKATEGORIA IN (1223) THEN 7591 --FÖLDRAJZ
|
|
WHEN C_TARGYKATEGORIA IN (1224) THEN 7592 --ÉNEK-ZENE
|
|
WHEN C_TARGYKATEGORIA IN (1229,1230) THEN 7593 --SZÁMÍTÁSTECHIKA, INFORMATIKA
|
|
WHEN C_TARGYKATEGORIA IN (1232,6755) THEN 7594 --TECHNIKA
|
|
WHEN C_TARGYKATEGORIA IN (1235) THEN 7595 --TESTNEVELÉS
|
|
WHEN C_TARGYKATEGORIA IN (6754,1215) THEN 7587 --TÖRTÉNELEM
|
|
WHEN C_TARGYKATEGORIA IN (1240,1269,1286,1274,1288,1277,1279,1273,1275,1284,1278,6749,6707,6750,1281,1287,1272,1280,1271,6751,
|
|
1270,1283,1276,1285,6752) THEN 7597 --SZAKMAI GYAKORLAT
|
|
WHEN C_TARGYKATEGORIA IN (1239,1249,1266,1254,1268,1257,1259,1253,1255,1264,1258,6745,6746,6706,1261,1267,1252,1260,1251,6747,
|
|
1250,1263,1256,1265,6748) THEN 7596 --SZAKMAI ELMÉLET
|
|
ELSE 7598 --EGYÉB
|
|
END
|
|
FROM T_TANTARGY tgy
|
|
INNER JOIN T_TANEV tn ON tn.ID = tgy.C_TANEVID AND tn.TOROLT='F' AND tn.C_AKTIV = 'T' AND tn.C_NEV = '2019/2020'
|
|
INNER JOIN T_INTEZMENY i ON i.ID = tgy.C_INTEZMENYID AND i.TOROLT='F'
|
|
WHERE tgy.TOROLT='F' |