11 lines
2.6 KiB
SQL
11 lines
2.6 KiB
SQL
update DIB set DIB.C_NAME = N'Orvosi igazolás', DIB.C_TYPE = N'IgazolasTipus', DIB.C_PROTECTED = N'T', 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 = 1530;
|
|
update DIB set DIB.C_NAME = N'Szülői igazolás', DIB.C_TYPE = N'IgazolasTipus', DIB.C_PROTECTED = N'T', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 2 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1531;
|
|
update DIB set DIB.C_NAME = N'Hivatalos távollét', DIB.C_TYPE = N'IgazolasTipus', DIB.C_PROTECTED = N'T', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 4 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1532;
|
|
update DIB set DIB.C_NAME = N'Iskolaérdekű távollét', DIB.C_TYPE = N'IgazolasTipus', DIB.C_PROTECTED = N'T', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 3 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 1533;
|
|
update DIB set DIB.C_NAME = N'Szolgáltatói igazolás', DIB.C_TYPE = N'IgazolasTipus', DIB.C_PROTECTED = N'T', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 8 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6494;
|
|
update DIB set DIB.C_NAME = N'Iskolai engedély', DIB.C_TYPE = N'IgazolasTipus', DIB.C_PROTECTED = N'T', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 7 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6495;
|
|
update DIB set DIB.C_NAME = N'Kikérő', DIB.C_TYPE = N'IgazolasTipus', DIB.C_PROTECTED = N'T', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 5 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6834;
|
|
update DIB set DIB.C_NAME = N'Pályaválasztási célú igazolás', DIB.C_TYPE = N'IgazolasTipus', DIB.C_PROTECTED = N'T', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 6 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6967;
|
|
update DIB set DIB.C_NAME = N'Táppénz', DIB.C_TYPE = N'IgazolasTipus', DIB.C_PROTECTED = N'T', DIB.C_VISIBLE = N'T', DIB.C_ORDER = 9 FROM T_DICTIONARYITEMBASE DIB INNER JOIN T_TANEV t ON t.ID = DIB.C_TANEVID AND t.C_NEV = '2019/2020' WHERE DIB.ID = 6853;
|
|
update DIB set DIB.C_NAME = N'Egyéb igazolás', DIB.C_TYPE = N'IgazolasTipus', DIB.C_PROTECTED = N'T', 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 = 1529;
|