albert/kreta
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
main
kreta/Kreta.DataAccess.Migrations/Scripts/Archive/20190815021135_KRETA2_690/KRETA2_690.sql
skidoodle e124a47765 init
2024-03-13 00:33:46 +01:00

97 lines
20 KiB
SQL
Raw Permalink Blame History

update DIB set DIB.C_NAME = N'Na', DIB.C_NAME_1 = N'Na', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 1 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1296;
update DIB set DIB.C_NAME = N'Kis', DIB.C_NAME_1 = N'Kis', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 101 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1297;
update DIB set DIB.C_NAME = N'Középső', DIB.C_NAME_1 = N'Középső', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 102 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1298;
update DIB set DIB.C_NAME = N'Nagy középső', DIB.C_NAME_1 = N'Nagy középső', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 103 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6470;
update DIB set DIB.C_NAME = N'Nagy', DIB.C_NAME_1 = N'Nagy', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 104 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1299;
update DIB set DIB.C_NAME = N'Óvodai vegyes', DIB.C_NAME_1 = N'Óvodai vegyes', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 105 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1300;
update DIB set DIB.C_NAME = N'Előképző 1', DIB.C_NAME_1 = N'Előképző 1', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 106 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1301;
update DIB set DIB.C_NAME = N'Előképző 2', DIB.C_NAME_1 = N'Előképző 2', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 107 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1302;
update DIB set DIB.C_NAME = N'1', DIB.C_NAME_1 = N'1', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 201 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1303;
update DIB set DIB.C_NAME = N'2', DIB.C_NAME_1 = N'2', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 202 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1304;
update DIB set DIB.C_NAME = N'3', DIB.C_NAME_1 = N'3', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 203 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1305;
update DIB set DIB.C_NAME = N'4', DIB.C_NAME_1 = N'4', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 204 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1306;
update DIB set DIB.C_NAME = N'5', DIB.C_NAME_1 = N'5', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 205 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1307;
update DIB set DIB.C_NAME = N'6', DIB.C_NAME_1 = N'6', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 206 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1308;
update DIB set DIB.C_NAME = N'7', DIB.C_NAME_1 = N'7', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 207 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1309;
update DIB set DIB.C_NAME = N'8', DIB.C_NAME_1 = N'8', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 208 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1310;
update DIB set DIB.C_NAME = N'9', DIB.C_NAME_1 = N'9', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 231 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1311;
update DIB set DIB.C_NAME = N'10', DIB.C_NAME_1 = N'10', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 241 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1312;
update DIB set DIB.C_NAME = N'11', DIB.C_NAME_1 = N'11', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 251 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1313;
update DIB set DIB.C_NAME = N'12', DIB.C_NAME_1 = N'12', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 261 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1314;
update DIB set DIB.C_NAME = N'13', DIB.C_NAME_1 = N'13', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 271 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1315;
update DIB set DIB.C_NAME = N'5/Ny', DIB.C_NAME_1 = N'5/Ny', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 301 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1330;
update DIB set DIB.C_NAME = N'7/Ny', DIB.C_NAME_1 = N'7/Ny', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 302 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1331;
update DIB set DIB.C_NAME = N'9/Ny', DIB.C_NAME_1 = N'9/Ny', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 303 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1332;
update DIB set DIB.C_NAME = N'9/Kny', DIB.C_NAME_1 = N'9/Kny', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 311 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1333;
update DIB set DIB.C_NAME = N'5/N', DIB.C_NAME_1 = N'5/N', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 321 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1334;
update DIB set DIB.C_NAME = N'7/N', DIB.C_NAME_1 = N'7/N', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 322 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1335;
update DIB set DIB.C_NAME = N'9/N', DIB.C_NAME_1 = N'9/N', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 323 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1336;
update DIB set DIB.C_NAME = N'9/AJKP', DIB.C_NAME_1 = N'9/AJKP', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 331 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 3019;
update DIB set DIB.C_NAME = N'9/AJTP', DIB.C_NAME_1 = N'9/AJTP', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 332 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 3018;
update DIB set DIB.C_NAME = N'9/E', DIB.C_NAME_1 = N'9/E', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 341 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 3020;
update DIB set DIB.C_NAME = N'KH/1/1', DIB.C_NAME_1 = N'KH', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 351 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6471;
update DIB set DIB.C_NAME = N'KH/2/1/C', DIB.C_NAME_1 = N'KH', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 352 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6472;
update DIB set DIB.C_NAME = N'KH/2/1/A', DIB.C_NAME_1 = N'KH', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 353 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6473;
update DIB set DIB.C_NAME = N'KH/2/2/A', DIB.C_NAME_1 = N'KH', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 354 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6474;
update DIB set DIB.C_NAME = N'KH/2/1/B', DIB.C_NAME_1 = N'KH', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 355 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6475;
update DIB set DIB.C_NAME = N'KH/2/2/B', DIB.C_NAME_1 = N'KH', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 356 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6476;
update DIB set DIB.C_NAME = N'SZH/1', DIB.C_NAME_1 = N'SZH/1', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 361 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6477;
update DIB set DIB.C_NAME = N'SZH/2', DIB.C_NAME_1 = N'SZH/2', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 362 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6478;
update DIB set DIB.C_NAME = N'SZH/1/A', DIB.C_NAME_1 = N'SZH/1', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 363 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6479;
update DIB set DIB.C_NAME = N'SZH/2/A', DIB.C_NAME_1 = N'SZH/2', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 364 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6480;
update DIB set DIB.C_NAME = N'SZH/1/B', DIB.C_NAME_1 = N'SZH/1', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 365 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6481;
update DIB set DIB.C_NAME = N'SZH/2/B', DIB.C_NAME_1 = N'SZH/2', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 366 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6482;
update DIB set DIB.C_NAME = N'1/8', DIB.C_NAME_1 = N'1/8', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 401 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1324;
update DIB set DIB.C_NAME = N'1/9', DIB.C_NAME_1 = N'1/9', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 411 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1316;
update DIB set DIB.C_NAME = N'2/10', DIB.C_NAME_1 = N'2/10', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 412 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1323;
update DIB set DIB.C_NAME = N'3/11', DIB.C_NAME_1 = N'3/11', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 413 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1325;
update DIB set DIB.C_NAME = N'4/12', DIB.C_NAME_1 = N'4/12', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 417 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6520;
update DIB set DIB.C_NAME = N'5/13', DIB.C_NAME_1 = N'5/13', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 418 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6469;
update DIB set DIB.C_NAME = N'1/11', DIB.C_NAME_1 = N'1/11', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 421 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1317;
update DIB set DIB.C_NAME = N'2/12', DIB.C_NAME_1 = N'2/12', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 422 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1318;
update DIB set DIB.C_NAME = N'3/13', DIB.C_NAME_1 = N'3/13', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 423 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1322;
update DIB set DIB.C_NAME = N'1/13', DIB.C_NAME_1 = N'1/13', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 431 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1319;
update DIB set DIB.C_NAME = N'2/14', DIB.C_NAME_1 = N'2/14', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 433 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1320;
update DIB set DIB.C_NAME = N'3/15', DIB.C_NAME_1 = N'3/15', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 435 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1321;
update DIB set DIB.C_NAME = N'4/16', DIB.C_NAME_1 = N'4/16', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 436 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6468;
update DIB set DIB.C_NAME = N'1/12', DIB.C_NAME_1 = N'1/12', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 441 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1326;
update DIB set DIB.C_NAME = N'1/15', DIB.C_NAME_1 = N'1/15', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 443 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1337;
update DIB set DIB.C_NAME = N'Ksz/11', DIB.C_NAME_1 = N'Ksz/11', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 451 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 3016;
update DIB set DIB.C_NAME = N'Ksz/12', DIB.C_NAME_1 = N'Ksz/12', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 453 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 3017;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 64 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 3021;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 65 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 3022;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 66 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6702;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 67 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6703;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 68 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6704;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 69 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6705;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 70 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6818;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 71 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6819;
update DIB set DIB.C_NAME = N'Összevont 1-2', DIB.C_NAME_1 = N'Összevont 1-2', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 502 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6908;
update DIB set DIB.C_NAME = N'Összevont 1-3', DIB.C_NAME_1 = N'Összevont 1-3', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 503 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6909;
update DIB set DIB.C_NAME = N'Összevont 1-4', DIB.C_NAME_1 = N'Összevont 1-4', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 504 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6910;
update DIB set DIB.C_NAME = N'Összevont 2-3', DIB.C_NAME_1 = N'Összevont 2-3', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 505 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6911;
update DIB set DIB.C_NAME = N'Összevont 2-4', DIB.C_NAME_1 = N'Összevont 2-4', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 506 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6912;
update DIB set DIB.C_NAME = N'Összevont 3-4', DIB.C_NAME_1 = N'Összevont 3-4', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 507 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6913;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 78 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7109;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 79 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7110;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 80 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7111;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 81 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7112;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 82 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7113;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 83 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7114;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 84 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7115;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 85 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7116;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 86 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7117;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 87 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7118;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 88 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7119;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 89 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7120;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 90 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7121;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 91 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7122;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 92 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7123;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 93 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7124;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 94 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7125;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 95 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7126;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 96 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7127;
update DIB set DIB.C_VISIBLE = N'T', DIB.C_ORDER = 97 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7128;
update DIB set DIB.C_NAME = N'Kollégium', DIB.C_NAME_1 = N'Kollégium', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 601 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7129;
update DIB set DIB.C_NAME = N'Összevont osztály', DIB.C_NAME_1 = N'Összevont osztály', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 501 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 7366;
Reference in New Issue View Git Blame Copy Permalink