DELETE FROM [basedata].[dbo].[VINDecodeModel] WHERE YearCode = 'G' OR YearCode = 'H' OR YearCode = 'J' ;
INSERT INTO [basedata].[dbo].[VINDecodeModel] ( VinStartPos, VinEndPos, VinCompare, fkVehicleModel, fkModelYear, fkBodyStyle, fkPartnerGroup, ChassisNoFrom, ChassisNoTo, YearCodePos, YearCode, ObjVersion)
SELECT VinStartPos, VinEndPos, VinCompare, fkVehicleModel, fkModelYear, fkBodyStyle, fkPartnerGroup, ChassisNoFrom, ChassisNoTo, YearCodePos, 'G', ObjVersion
FROM [basedata].[dbo].[VINDecodeModel]
WHERE YearCode = 'F';
INSERT INTO [basedata].[dbo].[VINDecodeModel] ( VinStartPos, VinEndPos, VinCompare, fkVehicleModel, fkModelYear, fkBodyStyle, fkPartnerGroup, ChassisNoFrom, ChassisNoTo, YearCodePos, YearCode, ObjVersion)
SELECT VinStartPos, VinEndPos, VinCompare, fkVehicleModel, fkModelYear, fkBodyStyle, fkPartnerGroup, ChassisNoFrom, ChassisNoTo, YearCodePos, 'H', ObjVersion
FROM [basedata].[dbo].[VINDecodeModel]
WHERE YearCode = 'F';
INSERT INTO [basedata].[dbo].[VINDecodeModel] ( VinStartPos, VinEndPos, VinCompare, fkVehicleModel, fkModelYear, fkBodyStyle, fkPartnerGroup, ChassisNoFrom, ChassisNoTo, YearCodePos, YearCode, ObjVersion)
SELECT VinStartPos, VinEndPos, VinCompare, fkVehicleModel, fkModelYear, fkBodyStyle, fkPartnerGroup, ChassisNoFrom, ChassisNoTo, YearCodePos, 'J', ObjVersion
FROM [basedata].[dbo].[VINDecodeModel]
WHERE YearCode = 'F';