﻿--Migration

UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 01, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7921
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 02, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7922
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 03, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7923
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 04, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7924
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 05, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7925
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 06, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7926
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 07, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7927
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 08, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7928
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 09, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7929
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 10, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7930
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 11, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7931
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 12, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7932
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 13, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7933
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 14, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7934
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 15, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7935
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 16, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7936
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 17, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7937
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 18, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7938
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 19, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7939
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 20, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7940
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 21, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7941
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 22, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7942
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 23, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7943
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 24, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7944
UPDATE T_AGAZATUJSZKTTIPUS SET C_AGAZATIBESOROLAS = 25, SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 9065

UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0724 01 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7947
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0724 01 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7948
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0724 01 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7949
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0724 01 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7950
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0724 01 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7951
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0715 01 06', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7952
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0715 01 07', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7953
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0911 02 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7954
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0914 02 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7955
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0914 02 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7956
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0913 03 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7957
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0913 03 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8389
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0913 03 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7958
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0914 03 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7959
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0913 03 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7960
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0914 03 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7961
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0913 03 11', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8390
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0915 03 06', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7962
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0910 03 07', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7963
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0914 03 08', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7964
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0923 03 09', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7965
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0914 03 10', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7966
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0714 04 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7967
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0713 04 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7968
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0714 04 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7969
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0713 04 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7970
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0714 04 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7971
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0714 04 06', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7972
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0713 04 07', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7973
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0721 05 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7974
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0721 05 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7975
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0721 05 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7976
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0721 05 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7977
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0721 05 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7978
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0721 05 06', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7979
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0721 05 07', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7980
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0721 05 08', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7981
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0721 05 09', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7982
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0721 05 10', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7983
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0721 05 11', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7984
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0721 05 12', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7985
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0721 05 13', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7986
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0721 05 14', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7987
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0721 05 15', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7988
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0721 05 16', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7989
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0721 05 17', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7990
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0721 05 18', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7991
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 06 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7992
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 06 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7993
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 06 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7994
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 06 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7995
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 06 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7996
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0732 06 06', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7997
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 06 07', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7998
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 06 08', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 7999
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0732 06 09', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8000
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0732 06 10', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8001
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 06 11', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8002
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 06 12', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8003
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 06 13', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8004
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 06 14', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8005
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 06 15', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8006
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0732 06 16', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8007
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0732 07 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8008
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 07 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8009
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 07 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8010
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 07 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8011
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0722 08 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8012
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0722 08 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8013
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0723 08 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8014
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0411 09 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8015
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0411 09 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8016
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0715 10 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8017
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0715 10 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8018
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0732 10 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8019
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0715 10 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8020
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0715 10 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8021
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0715 10 06', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8022
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0715 10 07', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8023
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0715 10 08', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8024
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0715 10 09', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8025
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0716 10 10', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8026
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0716 10 11', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8027
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0715 10 12', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8028
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0716 10 13', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8029
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1031 11 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8030
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1031 11 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8031
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1031 11 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8032
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1031 11 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8033
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1031 11 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8034
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0612 12 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8035
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0612 12 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8036
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0613 12 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8037
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0714 12 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8038
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0417 13 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8039
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0416 13 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8040
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0416 13 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8041
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0712 14 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8042
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0712 14 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8043
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 1021 14 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8044
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1021 14 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8045
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1041 15 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8046
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 1041 15 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8047
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0722 15 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8048
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0716 15 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8049
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1041 15 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8050
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1041 15 06', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8051
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1041 15 07', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8052
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1041 15 08', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8053
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0723 16 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8054
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0212 16 07', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8060
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0212 16 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8055
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0723 16 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8056
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0213 16 08', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8061
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0213 16 09', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8062
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0211 16 13', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8066
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0214 16 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8057
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0723 16 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8058
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0211 16 10', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8063
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0211 16 11', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8064
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0211 16 12', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8065
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0413 16 14', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8067
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0723 16 06', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8059
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0821 17 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8069
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0821 17 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8068
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0810 17 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8070
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0811 17 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8071
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0812 17 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8072
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0812 17 06', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8073
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0810 17 07', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8074
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0810 17 08', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8075
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0811 17 09', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8076
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0413 18 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8077
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 1032 18 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8078
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1032 18 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8079
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0716 19 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8080
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0716 19 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8081
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0715 19 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8082
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0716 19 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8083
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0716 19 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8084
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0715 19 06', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8085
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0715 19 07', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8086
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0716 19 08', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8087
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0714 19 09', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8088
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0716 19 10', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8089
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0716 19 11', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8090
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0714 19 12', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8091
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0714 19 13', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8092
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1014 20 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8093
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1014 20 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8094
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1012 21 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8095
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1012 21 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8096
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1012 21 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8097
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0922 22 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8098
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0922 22 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8099
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0923 22 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8100
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0923 22 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8101
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0923 22 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8102
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0923 22 06', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8103
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 1013 23 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8104
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1013 23 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8105
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 1013 23 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8106
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 1013 23 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8107
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 1013 23 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8108
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1013 23 06', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8109
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1015 23 07', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8110
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 1013 23 08', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8111
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0722 24 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8112
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0722 24 02', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8113
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0711 24 03', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8114
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0722 24 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8115
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0722 24 05', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8116
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0722 24 06', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8117
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0722 24 07', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8118
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0711 24 08', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8119
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0711 24 09', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 8120
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0913 03 04', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 9066
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0913 03 12', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 9067
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '4 0716 19 14', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 9068
UPDATE T_SZAKMATIPUS SET C_SZAKKEPESITESAZONOSITOSZAM = '5 0188 25 01', SERIAL += 1, LASTCHANGED = GETDATE(), MODIFIER = 0 WHERE ID = 9069

INSERT INTO T_UJSZKTSZAKMAJEGYZEKOSSZEREND (C_OKTATASINEVELESIFELADATID, C_AGAZATUJSZKTTIPUSID, C_SZAKMATIPUSID, C_SZAKMAIRANYTIPUSID, C_INTEZMENYID, C_TANEVID, CREATOR, MODIFIER)
SELECT C_OKTATASINEVELESIFELADATID, C_AGAZATUJSZKTTIPUSID, C_SZAKMATIPUSID, C_SZAKMAIRANYTIPUSID, i.ID, t.ID, 0, 0 FROM (VALUES
  (7895, 7921, 7947, NULL),
  (7896, 7921, 7948, NULL),
  (7896, 7921, 7949, NULL),
  (7896, 7921, 7950, NULL),
  (7895, 7921, 7951, NULL),
  (7895, 7921, 7952, 8123),
  (7895, 7921, 7952, 8124),
  (7896, 7921, 7953, 8125),
  (7896, 7921, 7953, 8126),
  (7895, 7922, 7954, NULL),
  (7896, 7922, 7955, NULL),
  (7895, 7922, 7956, NULL),
  (7895, 7923, 8389, NULL),
  (7895, 7923, 7958, 8391),
  (7895, 7923, 7958, 8141),
  (7895, 7923, 7958, 8142),
  (7895, 7923, 7958, 8143),
  (7895, 7923, 7958, 8144),
  (7895, 7923, 7958, 8145),
  (7895, 7923, 7958, 8146),
  (7895, 7923, 7958, 8147),
  (7895, 7923, 7959, 8148),
  (7895, 7923, 7959, 8149),
  (7895, 7923, 7960, NULL),
  (7895, 7923, 7961, 8153),
  (7895, 7923, 7961, 8154),
  (7895, 7923, 7961, 8155),
  (7895, 7923, 8390, NULL),
  (7895, 7923, 7962, NULL),
  (7895, 7923, 7963, 8156),
  (7895, 7923, 7963, 8158),
  (7895, 7923, 7964, 8159),
  (7895, 7923, 7964, 8157),
  (7895, 7923, 7964, 8392),
  (7895, 7923, 7964, 8161),
  (7895, 7923, 7965, 8164),
  (7895, 7923, 7965, 8163),
  (7895, 7923, 7966, 8165),
  (7895, 7923, 7966, 8166),
  (7895, 7924, 7967, 8167),
  (7895, 7924, 7967, 8168),
  (7895, 7924, 7967, 8169),
  (7895, 7924, 7967, 8170),
  (7896, 7924, 7968, NULL),
  (7895, 7924, 7969, NULL),
  (7895, 7924, 7970, NULL),
  (7895, 7924, 7971, NULL),
  (7895, 7924, 7972, NULL),
  (7896, 7924, 7973, 8171),
  (7896, 7924, 7973, 8172),
  (7896, 7924, 7973, 8173),
  (7895, 7925, 7974, NULL),
  (7896, 7925, 7975, NULL),
  (7895, 7925, 7976, NULL),
  (7895, 7925, 7977, NULL),
  (7896, 7925, 7978, NULL),
  (7895, 7925, 7979, NULL),
  (7896, 7925, 7980, NULL),
  (7896, 7925, 7981, NULL),
  (7895, 7925, 7982, NULL),
  (7896, 7925, 7983, NULL),
  (7896, 7925, 7984, NULL),
  (7896, 7925, 7985, NULL),
  (7895, 7925, 7986, NULL),
  (7896, 7925, 7987, NULL),
  (7895, 7925, 7988, NULL),
  (7896, 7925, 7989, NULL),
  (7895, 7925, 7990, NULL),
  (7896, 7925, 7991, NULL),
  (7896, 7926, 7992, NULL),
  (7896, 7926, 7993, NULL),
  (7896, 7926, 7994, NULL),
  (7896, 7926, 7995, NULL),
  (7896, 7926, 7996, NULL),
  (7895, 7926, 7997, NULL),
  (7896, 7926, 7998, NULL),
  (7896, 7926, 7999, NULL),
  (7895, 7926, 8000, NULL),
  (7895, 7926, 8001, NULL),
  (7896, 7926, 8002, NULL),
  (7896, 7926, 8003, NULL),
  (7896, 7926, 8004, NULL),
  (7896, 7926, 8005, NULL),
  (7896, 7926, 8006, NULL),
  (7895, 7926, 8007, NULL),
  (7895, 7927, 8008, NULL),
  (7896, 7927, 8009, NULL),
  (7896, 7927, 8010, NULL),
  (7896, 7927, 8011, NULL),
  (7896, 7928, 8012, NULL),
  (7895, 7928, 8013, NULL),
  (7896, 7928, 8014, NULL),
  (7895, 7929, 8015, NULL),
  (7895, 7929, 8016, NULL),
  (7896, 7930, 8017, NULL),
  (7896, 7930, 8018, NULL),
  (7896, 7930, 8019, NULL),
  (7896, 7930, 8020, NULL),
  (7895, 7930, 8021, 8174),
  (7895, 7930, 8021, 8175),
  (7895, 7930, 8021, 8176),
  (7895, 7930, 8022, NULL),
  (7896, 7930, 8023, NULL),
  (7896, 7930, 8024, NULL),
  (7896, 7930, 8025, 8175),
  (7896, 7930, 8025, 8176),
  (7895, 7930, 8026, NULL),
  (7895, 7930, 8027, NULL),
  (7896, 7930, 8028, NULL),
  (7895, 7930, 8029, NULL),
  (7895, 7931, 8030, NULL),
  (7895, 7931, 8031, NULL),
  (7895, 7931, 8032, NULL),
  (7895, 7931, 8033, 8177),
  (7895, 7931, 8033, 8178),
  (7895, 7931, 8033, 8179),
  (7895, 7931, 8033, 8180),
  (7895, 7931, 8033, 8181),
  (7895, 7931, 8033, 8182),
  (7895, 7931, 8033, 8183),
  (7895, 7931, 8033, 8184),
  (7895, 7931, 8033, 8185),
  (7895, 7931, 8033, 8186),
  (7895, 7931, 8033, 8187),
  (7895, 7931, 8033, 8188),
  (7895, 7931, 8033, 8189),
  (7895, 7931, 8033, 8190),
  (7895, 7931, 8033, 8191),
  (7895, 7931, 8034, 8192),
  (7895, 7931, 8034, 8193),
  (7895, 7931, 8034, 8194),
  (7895, 7931, 8034, 8195),
  (7895, 7931, 8034, 8196),
  (7895, 7931, 8034, 8197),
  (7895, 7931, 8034, 8198),
  (7895, 7932, 8035, NULL),
  (7895, 7932, 8036, NULL),
  (7895, 7932, 8037, NULL),
  (7895, 7932, 8038, NULL),
  (7895, 7933, 8039, 8199),
  (7895, 7933, 8039, 8200),
  (7895, 7933, 8039, 8201),
  (7896, 7933, 8040, NULL),
  (7895, 7933, 8041, NULL),
  (7896, 7934, 8042, NULL),
  (7895, 7934, 8043, 8202),
  (7895, 7934, 8043, 8203),
  (7895, 7934, 8043, 8204),
  (7895, 7934, 8043, 8205),
  (7896, 7934, 8044, NULL),
  (7895, 7934, 8045, 8206),
  (7895, 7934, 8045, 8207),
  (7895, 7934, 8045, 8208),
  (7895, 7935, 8046, NULL),
  (7896, 7935, 8047, NULL),
  (7896, 7935, 8048, NULL),
  (7895, 7935, 8049, NULL),
  (7895, 7935, 8050, 8209),
  (7895, 7935, 8050, 8210),
  (7895, 7935, 8050, 8211),
  (7895, 7935, 8050, 8212),
  (7895, 7935, 8051, 8213),
  (7895, 7935, 8051, 8214),
  (7895, 7935, 8052, NULL),
  (7895, 7935, 8053, NULL),
  (7896, 7936, 8054, 8215),
  (7896, 7936, 8054, 8216),
  (7896, 7936, 8054, 8217),
  (7895, 7936, 8060, NULL),
  (7895, 7936, 8055, 8218),
  (7895, 7936, 8055, 8219),
  (7896, 7936, 8056, 8221),
  (7896, 7936, 8056, 8220),
  (7895, 7936, 8061, 8232),
  (7895, 7936, 8061, 8233),
  (7895, 7936, 8062, NULL),
  (7895, 7936, 8066, NULL),
  (7896, 7936, 8057, 8222),
  (7896, 7936, 8057, 8223),
  (7896, 7936, 8057, 8224),
  (7895, 7936, 8058, 8225),
  (7895, 7936, 8058, 8216),
  (7895, 7936, 8058, 8217),
  (7895, 7936, 8058, 8226),
  (7895, 7936, 8058, 8227),
  (7895, 7936, 8063, NULL),
  (7895, 7936, 8064, 8234),
  (7895, 7936, 8064, 8235),
  (7895, 7936, 8064, 8236),
  (7896, 7936, 8065, 8234),
  (7896, 7936, 8065, 8235),
  (7896, 7936, 8065, 8236),
  (7895, 7936, 8067, 8241),
  (7895, 7936, 8067, 8237),
  (7895, 7936, 8067, 8238),
  (7895, 7936, 8067, 8239),
  (7895, 7936, 8067, 8240),
  (7896, 7936, 8059, 8228),
  (7896, 7936, 8059, 8229),
  (7896, 7936, 8059, 8230),
  (7896, 7936, 8059, 8231),
  (7895, 7937, 8069, 8242),
  (7895, 7937, 8069, 8243),
  (7896, 7937, 8068, NULL),
  (7895, 7937, 8070, NULL),
  (7896, 7937, 8071, 8244),
  (7896, 7937, 8071, 8245),
  (7896, 7937, 8071, 8246),
  (7896, 7937, 8072, NULL),
  (7895, 7937, 8073, 8247),
  (7895, 7937, 8073, 8248),
  (7895, 7937, 8073, 8249),
  (7895, 7937, 8073, 8250),
  (7895, 7937, 8073, 8251),
  (7896, 7937, 8074, NULL),
  (7895, 7937, 8075, NULL),
  (7895, 7937, 8076, 8244),
  (7895, 7937, 8076, 8246),
  (7895, 7938, 8077, 8252),
  (7895, 7938, 8077, 8253),
  (7896, 7938, 8078, NULL),
  (7895, 7938, 8079, 8254),
  (7895, 7938, 8079, 8255),
  (7895, 7938, 8079, 8256),
  (7895, 7938, 8079, 8257),
  (7895, 7939, 8080, NULL),
  (7896, 7939, 8081, NULL),
  (7896, 7939, 8082, NULL),
  (7895, 7939, 8083, 8258),
  (7895, 7939, 8083, 8259),
  (7895, 7939, 8083, 8260),
  (7896, 7939, 8084, 8261),
  (7896, 7939, 8084, 8260),
  (7896, 7939, 8084, 8258),
  (7896, 7939, 8085, NULL),
  (7895, 7939, 8086, NULL),
  (7896, 7939, 8087, NULL),
  (7895, 7939, 8088, NULL),
  (7896, 7939, 8089, NULL),
  (7896, 7939, 8090, NULL),
  (7895, 7939, 8091, NULL),
  (7896, 7939, 8092, NULL),
  (7895, 7940, 8093, NULL),
  (7895, 7940, 8094, NULL),
  (7895, 7941, 8095, NULL),
  (7895, 7941, 8096, 8262),
  (7895, 7941, 8096, 8263),
  (7895, 7941, 8097, NULL),
  (7896, 7942, 8098, NULL),
  (7895, 7942, 8099, NULL),
  (7896, 7942, 8100, NULL),
  (7895, 7942, 8101, NULL),
  (7895, 7942, 8102, NULL),
  (7895, 7942, 8103, NULL),
  (7896, 7943, 8104, NULL),
  (7895, 7943, 8105, NULL),
  (7896, 7943, 8106, NULL),
  (7896, 7943, 8107, NULL),
  (7896, 7943, 8108, NULL),
  (7895, 7943, 8109, NULL),
  (7895, 7943, 8110, 8264),
  (7895, 7943, 8110, 8265),
  (7895, 7943, 8111, NULL),
  (7896, 7944, 8112, NULL),
  (7895, 7944, 8113, NULL),
  (7896, 7944, 8114, NULL),
  (7896, 7944, 8115, NULL),
  (7895, 7944, 8116, NULL),
  (7896, 7944, 8117, 8267),
  (7896, 7944, 8117, 8266),
  (7895, 7944, 8118, 8267),
  (7895, 7944, 8118, 8266),
  (7895, 7944, 8119, 8268),
  (7895, 7944, 8119, 8269),
  (7896, 7944, 8120, NULL),
  (7895, 7923, 9066, NULL),
  (7896, 7923, 9067, NULL),
  (7896, 7939, 9068, NULL),
  (7895, 9065, 9069, NULL)) sq (C_OKTATASINEVELESIFELADATID, C_AGAZATUJSZKTTIPUSID, C_SZAKMATIPUSID, C_SZAKMAIRANYTIPUSID)
  CROSS JOIN T_TANEV t
  INNER JOIN T_INTEZMENY i on i.ID = t.C_INTEZMENYID
  WHERE t.TOROLT = 'F' AND i.TOROLT = 'F' and (t.C_AKTIV = 'T' OR t.C_KOVETKEZO = 'T') AND i.C_ISARCHIV = 'F'
