SET DATEFORMAT ymd

INSERT INTO CM_BRANCH_DEP_MAP (HR_ID, KT_ID) VALUES
('0', NULL),
('00', '05E10'),
('00.00.58', '05R00'),
('00.2021.02', '05F02'),
('00.2021.03', '05F01'),
('00.2021.04', '05F03'),
('00.2021.05', '05F04'),
('00.2021.06', '05F05'),
('00.2021.07', '05F06'),
('00.2021.09', '05G05'),
('00.2021.10', '05O01'),
('00.2021.11', '05O02'),
('00.2021.12', '05O03'),
('00.2021.13', '05O04'),
('00.2021.14', '05H01'),
('00.2021.15', '05I04'),
('00.2021.16', '05G01'),
('00.2022.01', '05A00'),
('00.2022.02', NULL),
('00.2022.03', '05E12'),
('00.2022.04', '05X00'),
('00.2022.05', '05X00'),
('00.2022.06', '0700'),
('00.2022.07', NULL),
('0000', '0500'),
('00x', '05C00'),
('00xx', '05E00'),
('00XXX', '05D00'),
('00XXX.01', '05D01'),
('00XXX.02', '05D02'),
('00XXX.03', '05D03'),
('00XXX.04', '05D04'),
('01', '05F00'),
('01.01.00', NULL),
('01.01.01', NULL),
('01.01.02', NULL),
('01.01.03', NULL),
('01.01.04', NULL),
('01.01.05', NULL),
('01.02.06', NULL),
('01.02.07', NULL),
('01.03.09', NULL),
('01.03.10', NULL),
('01.03.11', NULL),
('01.04.12', NULL),
('01.04.13', NULL),
('01.04.14', NULL),
('02', '05G00'),
('02.04', '05G02'),
('02.05.16', NULL),
('02.05.17', NULL),
('02.05.18', NULL),
('02.05.19', NULL),
('02.06.20', NULL),
('02.06.21', NULL),
('02.06.22', NULL),
('02.07.23', NULL),
('02.07.24', NULL),
('02.26', '05G04'),
('02.TTTTQT', '05G03'),
('03', '05H00'),
('03.00.26', '05H02'),
('03.00.27', '05H03'),
('04', '05I00'),
('04.00.28', '05I01'),
('04.00.29', '05I02'),
('04.00.30', '05I03'),
('05', '05J00'),
('05.00.31', '05J01'),
('05.00.32', '05J02'),
('05.00.33', '05J03'),
('05.00.34', '05J04'),
('05.00.35', '05J05'),
('06', '05K00'),
('06.00.36', '05K01'),
('06.00.37', '05K02'),
('06.00.38', NULL),
('06.00.39', '05K03'),
('06.00.40', '05K04'),
('07', '05L00'),
('07.00.41', '05L01'),
('07.00.42', '05L02'),
('07.00.43', '05L03'),
('08', '05M00'),
('08.00.44', '05M01'),
('08.00.47', '05M03'),
('08.00.48', '05M04'),
('08.00.49', '05M05'),
('09', '05N00'),
('09.08', '05N10'),
('09.08.50', '05N11'),
('09.08.51', '05N12'),
('09.08.52', '05N13'),
('09.10', '05N20'),
('09.10.55', '05N21'),
('09.10.56', '05N22'),
('10', '05T00'),
('11', '05O00'),
('11.02', NULL),
('2022', NULL),
('2022.01', '05Y01'),
('2022.01.002', '1701'),
('2022.01.003', '1802'),
('2022.01.004', '0719'),
('2022.01.005', '0700'),
('2022.01.006', '0702'),
('2022.01.007', '0704'),
('2022.01.008', '0703'),
('2022.01.009', '0707'),
('2022.01.013', '1900'),
('2022.01.014', '2000'),
('2022.01.016', '2002'),
('2022.01.017', '2001'),
('2022.01.018', '0711'),
('2022.01.020', '0714'),
('2022.01.022', '0717'),
('2022.01.024', '0720'),
('2022.01.025', '0721'),
('2022.01.027', '1705'),
('2022.01.028', '0732'),
('2022.01.031', '1704'),
('2022.01.032', '1804'),
('2022.01.034', '0700'),
('2022.01.036', '0733'),
('2022.01.037', '1703'),
('2022.01.039', '1902'),
('2022.01.040', '0744'),
('2022.01.046', '0706'),
('2022.01.047', '1900'),
('2022.01.131', '2300'),
('2022.02', '05Y02'),
('2022.02.001', '1903'),
('2022.02.010', '0708'),
('2022.02.011', '1700'),
('2022.02.012', '1800'),
('2022.02.015', '1901'),
('2022.02.019', '0713'),
('2022.02.021', '0715'),
('2022.02.023', '0718'),
('2022.02.026', '1801'),
('2022.02.029', '1803'),
('2022.02.030', '1702'),
('2022.02.033', '1805'),
('2022.02.035', '0712'),
('2022.02.038', '0705'),
('2022.02.041', '0727'),
('2022.02.042', '0731'),
('2022.02.043', '0741'),
('2022.02.044', '0740'),
('2022.02.045', '0726'),
('2022.02.108', '1200'),
('2022.02.109', '1201'),
('2022.02.110', '1203'),
('2022.02.111', '1202'),
('2022.02.112', '1400'),
('2022.02.113', '1403'),
('2022.02.114', '1401'),
('2022.02.115', '1402'),
('2022.02.127', '2200'),
('2022.03', '05Y03'),
('2022.03.060', '0814'),
('2022.03.062', '0805'),
('2022.03.063', '0800'),
('2022.03.064', '0802'),
('2022.03.065', '0806'),
('2022.03.066', '0808'),
('2022.03.067', '0809'),
('2022.03.068', '0807'),
('2022.03.069', '0811'),
('2022.03.070', '0812'),
('2022.03.071', '0816'),
('2022.03.072', '0813'),
('2022.03.073', '0815'),
('2022.03.074', '0817'),
('2022.03.075', '0818'),
('2022.03.076', '0819'),
('2022.03.077', '0803'),
('2022.03.078', '0804'),
('2022.03.079', '0801'),
('2022.03.080', '0810'),
('2022.03.081', '0800'),
('2022.03.082', '0800'),
('2022.03.129', '2400'),
('2022.04', '05Y04'),
('2022.04.049', '0600'),
('2022.04.050', '0601'),
('2022.04.051', '0103'),
('2022.04.052', '0102'),
('2022.04.053', '0900'),
('2022.04.054', '0902'),
('2022.04.057', '0901'),
('2022.04.058', '0903'),
('2022.04.130', '2500'),
('2022.04.132', '2600'),
('2022.04.136', '3000'),
('2022.05', '05Y05'),
('2022.05.092', '1100'),
('2022.05.093', '1101'),
('2022.05.094', '1102'),
('2022.05.095', '1103'),
('2022.05.096', '1104'),
('2022.05.097', '1105'),
('2022.05.098', '1106'),
('2022.05.099', '1107'),
('2022.05.123', '1601'),
('2022.05.124', '1603'),
('2022.05.125', '1602'),
('2022.05.126', '1600'),
('2022.05.133', '2700'),
('2022.06', '05Y06'),
('2022.06.102', '1302'),
('2022.06.103', '1303'),
('2022.06.104', '1300'),
('2022.06.105', '1301'),
('2022.06.128', '2100'),
('2022.06.135', '2900'),
('2022.07', '05Y07'),
('2022.07.116', '1500'),
('2022.07.117', '1503'),
('2022.07.118', '1504'),
('2022.07.119', '1502'),
('2022.07.120', '1501'),
('2022.07.122', '1500'),
('2022.08', '05Y08'),
('2022.08.084', '1004'),
('2022.08.085', '1000'),
('2022.08.086', '1001'),
('2022.08.087', '1006'),
('2022.08.088', '1000'),
('2022.08.090', '1005'),
('2022.08.091', '1002'),
('2022.08.134', '2800'),
('21.0396', '0900'),
('21.0399', '0900'),
('21.0496', '0800'),
('21.0596', '1000'),
('21.0696', '1100'),
('21.0699', '1100'),
('21.0796', '1300'),
('21.0799', '1300'),
('21.1096', '1500'),
('21.2021.03', '0747'),
('21.2021.04', '0748'),
('21.x.05', NULL),
('21.x.13', NULL),
('24.2021.02', NULL),
('25.00.08', NULL),
('25.01.07', NULL),
('AMC', '05U00'),
('BGD_LD', '05E12'),
('BKS', '05B00'),
('DT.01', '05P11'),
('DT.02', '05P12'),
('DT.03', '05P13'),
('DT.04', '05P14'),
('KNNL', '05P00'),
('KTHTBC.19', '05D03'),
('KTMLKD.19', '05D01'),
('KTNB.19', '05D00'),
('KVAG', NULL),
('KVBD', NULL),
('KVBÐ', NULL),
('KVDNAI', NULL),
('KVKG', NULL),
('KVQN', NULL),
('KVQNA', NULL),
('KVVP', NULL),
('KVÐT', NULL),
('NNL.01', '05P21'),
('NNL.02', '05P22'),
('NNL.03', '05P23'),
('NNL.04', '05P24'),
('PCBNS', '05Q01'),
('PHQLBH', NULL),
('PQLN', '05Q02'),
('PTDBH', NULL),
('PTML', NULL),
('PXLN', '05Q03'),
('QLN', '05Q00'),
('TTB-KVHÐ', '0821'),
('TTDT', '05P10'),
('TTPTNNL', '05P20'),
('VHKT.19', '05D04'),
('VPKVMT', NULL)
GO