26 lines
5.3 KiB
SQL
26 lines
5.3 KiB
SQL
update DIB set DIB.C_NAME = 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 = 6084;
|
|
update DIB set DIB.C_NAME = N'Egészségügy - 1.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 10 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6085;
|
|
update DIB set DIB.C_NAME = N'Szociális szolgáltatások - 2.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 20 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6103;
|
|
update DIB set DIB.C_NAME = N'Oktatás - 3.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 30 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6101;
|
|
update DIB set DIB.C_NAME = N'Művészet, közművelődés, kommunikáció - 4.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 40 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6099;
|
|
update DIB set DIB.C_NAME = N'Gépészet - 5.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 50 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6091;
|
|
update DIB set DIB.C_NAME = N'Elektrotechnika-elektronika - 6.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 60 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6087;
|
|
update DIB set DIB.C_NAME = N'Informatika - 7.', 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 = 6092;
|
|
update DIB set DIB.C_NAME = N'Vegyipar - 8.', 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 = 6105;
|
|
update DIB set DIB.C_NAME = N'Építészet - 9.', 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 = 6089;
|
|
update DIB set DIB.C_NAME = N'Könnyűipar - 10.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 100 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6094;
|
|
update DIB set DIB.C_NAME = N'Faipar - 11.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 110 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6090;
|
|
update DIB set DIB.C_NAME = N'Nyomdaipar - 12.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 120 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6100;
|
|
update DIB set DIB.C_NAME = N'Közlekedés - 13.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 130 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6097;
|
|
update DIB set DIB.C_NAME = N'Környezetvédelem - 14.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 140 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6095;
|
|
update DIB set DIB.C_NAME = N'Környezetvédelem-vízgazdálkodás - 14. (2014)', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 300 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6831;
|
|
update DIB set DIB.C_NAME = N'Közgazdaság - 15.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 150 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6096;
|
|
update DIB set DIB.C_NAME = N'Ügyvitel - 16.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 160 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6104;
|
|
update DIB set DIB.C_NAME = N'Kereskedelem-marketing, üzleti adminisztráció - 17.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 170 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6093;
|
|
update DIB set DIB.C_NAME = N'Vendéglátás-turisztika - 18.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 180 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6106;
|
|
update DIB set DIB.C_NAME = N'Egyéb szolgáltatások - 19.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 190 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6086;
|
|
update DIB set DIB.C_NAME = N'Mezőgazdaság - 20.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 200 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6098;
|
|
update DIB set DIB.C_NAME = N'Élelmiszeripar - 21.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 210 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6088;
|
|
update DIB set DIB.C_NAME = N'Rendészet, honvédelem és közszolgálat - 22.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 220 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6102;
|
|
update DIB set DIB.C_NAME = N'Vízügy - 23.', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 230 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6107;
|