﻿--Migration
  
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1296 AND C_NAME_4 IS NULL; -- Na
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Kis' WHERE ID = 1297 AND C_NAME_4 IS NULL; -- Kis
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Középső' WHERE ID = 1298 AND C_NAME_4 IS NULL; -- Középső
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Nagy' WHERE ID = 1299 AND C_NAME_4 IS NULL; -- Nagy
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1300 AND C_NAME_4 IS NULL; -- Óvodai vegyes
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1301 AND C_NAME_4 IS NULL; -- Előképző 1
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1302 AND C_NAME_4 IS NULL; -- Előképző 2
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'1' WHERE ID = 1303 AND C_NAME_4 IS NULL; -- 1
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'2' WHERE ID = 1304 AND C_NAME_4 IS NULL; -- 2
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'3' WHERE ID = 1305 AND C_NAME_4 IS NULL; -- 3
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'4' WHERE ID = 1306 AND C_NAME_4 IS NULL; -- 4
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'5' WHERE ID = 1307 AND C_NAME_4 IS NULL; -- 5
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'6' WHERE ID = 1308 AND C_NAME_4 IS NULL; -- 6
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'7' WHERE ID = 1309 AND C_NAME_4 IS NULL; -- 7
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'8' WHERE ID = 1310 AND C_NAME_4 IS NULL; -- 8
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'9' WHERE ID = 1311 AND C_NAME_4 IS NULL; -- 9
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'10' WHERE ID = 1312 AND C_NAME_4 IS NULL; -- 10
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'11' WHERE ID = 1313 AND C_NAME_4 IS NULL; -- 11
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'12' WHERE ID = 1314 AND C_NAME_4 IS NULL; -- 12
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'13' WHERE ID = 1315 AND C_NAME_4 IS NULL; -- 13
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1316 AND C_NAME_4 IS NULL; -- 1/9
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1317 AND C_NAME_4 IS NULL; -- 1/11
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1318 AND C_NAME_4 IS NULL; -- 2/12
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1319 AND C_NAME_4 IS NULL; -- 1/13
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1320 AND C_NAME_4 IS NULL; -- 2/14
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1321 AND C_NAME_4 IS NULL; -- 3/15
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1322 AND C_NAME_4 IS NULL; -- 3/13
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1323 AND C_NAME_4 IS NULL; -- 2/10
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1324 AND C_NAME_4 IS NULL; -- 1/8
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1325 AND C_NAME_4 IS NULL; -- 3/11
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1326 AND C_NAME_4 IS NULL; -- 1/12
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'5' WHERE ID = 1330 AND C_NAME_4 IS NULL; -- 5/Ny
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'7' WHERE ID = 1331 AND C_NAME_4 IS NULL; -- 7/Ny
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'9' WHERE ID = 1332 AND C_NAME_4 IS NULL; -- 9/Ny
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'9' WHERE ID = 1333 AND C_NAME_4 IS NULL; -- 9/Kny
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'5' WHERE ID = 1334 AND C_NAME_4 IS NULL; -- 5/N
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'7' WHERE ID = 1335 AND C_NAME_4 IS NULL; -- 7/N
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'9' WHERE ID = 1336 AND C_NAME_4 IS NULL; -- 9/N
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 1337 AND C_NAME_4 IS NULL; -- 1/15
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 3016 AND C_NAME_4 IS NULL; -- Ksz/11
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 3017 AND C_NAME_4 IS NULL; -- Ksz/12
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'9' WHERE ID = 3018 AND C_NAME_4 IS NULL; -- 9/AJTP
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'9' WHERE ID = 3019 AND C_NAME_4 IS NULL; -- 9/AJKP
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 3020 AND C_NAME_4 IS NULL; -- 9/E
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 3021 AND C_NAME_4 IS NULL; -- Szél/12/1
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 3022 AND C_NAME_4 IS NULL; -- Szél/12/2
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6468 AND C_NAME_4 IS NULL; -- 4/16
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6469 AND C_NAME_4 IS NULL; -- 5/13
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6470 AND C_NAME_4 IS NULL; -- Nagy középső
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6471 AND C_NAME_4 IS NULL; -- KH/1/1
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6472 AND C_NAME_4 IS NULL; -- KH/2/1/C
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6473 AND C_NAME_4 IS NULL; -- KH/2/1/A
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6474 AND C_NAME_4 IS NULL; -- KH/2/2/A
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6475 AND C_NAME_4 IS NULL; -- KH/2/1/B
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6476 AND C_NAME_4 IS NULL; -- KH/2/2/B
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6477 AND C_NAME_4 IS NULL; -- SZH/1
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6478 AND C_NAME_4 IS NULL; -- SZH/2
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6479 AND C_NAME_4 IS NULL; -- SZH/1/A
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6480 AND C_NAME_4 IS NULL; -- SZH/2/A
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6481 AND C_NAME_4 IS NULL; -- SZH/1/B
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6482 AND C_NAME_4 IS NULL; -- SZH/2/B
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6520 AND C_NAME_4 IS NULL; -- 4/12
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6702 AND C_NAME_4 IS NULL; -- 9/S
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6703 AND C_NAME_4 IS NULL; -- 10/S
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6704 AND C_NAME_4 IS NULL; -- 11/S
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6705 AND C_NAME_4 IS NULL; -- 12/S
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6818 AND C_NAME_4 IS NULL; -- Kk 12
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6819 AND C_NAME_4 IS NULL; -- Kk 13
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6908 AND C_NAME_4 IS NULL; -- Összevont 1-2
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6909 AND C_NAME_4 IS NULL; -- Összevont 1-3
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6910 AND C_NAME_4 IS NULL; -- Összevont 1-4
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6911 AND C_NAME_4 IS NULL; -- Összevont2-3
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6912 AND C_NAME_4 IS NULL; -- Összevont 2-4
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 6913 AND C_NAME_4 IS NULL; -- Összevont3-4
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'7' WHERE ID = 7109 AND C_NAME_4 IS NULL; -- 7 gimnázium
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'8' WHERE ID = 7110 AND C_NAME_4 IS NULL; -- 8 gimnázium
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'9' WHERE ID = 7111 AND C_NAME_4 IS NULL; -- 9 szakgimnázium
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'9' WHERE ID = 7112 AND C_NAME_4 IS NULL; -- 9 gimnázium
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'9' WHERE ID = 7113 AND C_NAME_4 IS NULL; -- 9 szakiskola
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'9' WHERE ID = 7114 AND C_NAME_4 IS NULL; -- 9 készségfejlesztő iskola
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'10' WHERE ID = 7115 AND C_NAME_4 IS NULL; -- 10 szakgimnázium
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'10' WHERE ID = 7116 AND C_NAME_4 IS NULL; -- 10 gimnázium
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'10' WHERE ID = 7117 AND C_NAME_4 IS NULL; -- 10 szakiskola
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'10' WHERE ID = 7118 AND C_NAME_4 IS NULL; -- 10 készségfejlesztő iskola
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'11' WHERE ID = 7119 AND C_NAME_4 IS NULL; -- 11 szakgimnázium
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'11' WHERE ID = 7120 AND C_NAME_4 IS NULL; -- 11 gimnázium
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'11' WHERE ID = 7121 AND C_NAME_4 IS NULL; -- 11 szakiskola
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'11' WHERE ID = 7122 AND C_NAME_4 IS NULL; -- 11 készségfejlesztő iskola
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'12' WHERE ID = 7123 AND C_NAME_4 IS NULL; -- 12 szakgimnázium
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'12' WHERE ID = 7124 AND C_NAME_4 IS NULL; -- 12 gimnázium
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'12' WHERE ID = 7125 AND C_NAME_4 IS NULL; -- 12 szakiskola
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'12' WHERE ID = 7126 AND C_NAME_4 IS NULL; -- 12 készségfejlesztő iskola
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'9' WHERE ID = 7127 AND C_NAME_4 IS NULL; -- 9/Ny gimnázium nyelvi előkészítő
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'9' WHERE ID = 7128 AND C_NAME_4 IS NULL; -- 9/Kny gimnázium két tanítási nyelvű előkészítő
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 7129 AND C_NAME_4 IS NULL; -- Kollégium
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 7366 AND C_NAME_4 IS NULL; -- Összevont osztály
  UPDATE T_DICTIONARYITEMBASE SET C_NAME_4 = N'Na' WHERE ID = 7721 AND C_NAME_4 IS NULL; -- Szakképzést előkészítő évfolyam
  GO