C11/System/OPTIMA/SQL/batch/VEHICLE.bat

@echo off
call "C:\GlobalCube\Tasks\scripts\config2.bat"
rem ==VEHICLE==
del C:\GlobalCube\System\OPTIMA\SQL\logs\VEHICLE*.* /Q /F >nul 2>nul

if not "%1"=="" goto :increment

:full
  call sql_query.bat "TRUNCATE TABLE [OPTIMA].[import].[VEHICLE]"
rem Nur in Quelle: REG_NUMBER_SEARCH
  call bcp_queryout.bat "VEHICLE_1" "SELECT T1.[BASIS_NUMBER], T1.[STATE_CODE_CF], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[DEBIT_ACCOUNT], T1.[REGISTER_NUMBER], T1.[CHASSIS_NUMBER], T1.[CAR_GROUP], T1.[CAR_STATUS], T1.[FAC_MODEL_CODE_L], T1.[USER_CODE], T1.[OWNER_CODE], T1.[UNIT_ACCOUNTING_CF], T1.[CONTACT_PERSON], T1.[FIRST_REG_DATE], T1.[LATEST_REG_DATE], T1.[FIRST_OCCUR_DATE], T1.[EXPECTED_ARR_DATE], T1.[ARRIVAL_DATE], T1.[LAST_OWNER_CHANGE], T1.[SALESMAN_BUY], T1.[SALESMAN_SALE], T1.[MODEL_TEXT], T1.[ORIG_MODEL_CODE1], T1.[ORIG_MODEL_CODE2], T1.[COLOUR_CF], T1.[TRIM_TXT], T1.[MODEL_LINE], T1.[WORKSHOP_MODEL], T1.[FAC_MODEL_CODE_S], T1.[CLASSIFICATION], T1.[MOTOR_NUMBER], T1.[KEY_CODE], T1.[YEAR_MODEL_CF], T1.[CYLINDER_VOLUME], T1.[SEATS], T1.[DECLARATION_DATE], T1.[DECLARATION_PLACE], T1.[DECLARATION_NUMBER], T1.[ARRIVAL_SHIP], T1.[ARRIVAL_NUMBER], T1.[BILL_OF_LANDING], T1.[SCRUTINEERING_DATE], T1.[EQUIPMENT_1], T1.[EQUIPMENT_2], T1.[EQUIPMENT_3], T1.[EQUIPMENT_4], T1.[INSURANCE], T1.[INSURANCE_COMPANY], T1.[MILEAGE], T1.[MISC_1_CF], T1.[MISC_2_CF], T1.[MISC_3_CF], T1.[MISC_4_CF], T1.[MISC_5_CF], T1.[MISC_6_CF], T1.[MISC_7_CF], T1.[MISC_8_CF], T1.[MISC_9_CF], T1.[MISC_10_CF], T1.[LAST_INVOICE_DTE], T1.[CONTACT_DATE], T1.[MAIL_CODE_1], T1.[MAIL_CODE_2], T1.[MAIL_CODE_3], T1.[MAIL_CODE_4], T1.[MAIL_CODE_5], T1.[MAIL_CODE_6], T1.[MAIL_CODE_7], T1.[MAIL_CODE_8], T1.[MAIL_CODE_9], T1.[MOTOR_CODE], T1.[GEAR_CODE], T1.[DRIVE_CODE], T1.[COLOUR_CODE], T1.[TRIM_CODE], T1.[LATEST_UNIT_NO], T1.[FOLLOW_UP], T1.[NO_OF_OWNERS], T1.[CAR_LETTER], T1.[TUV_TYPE], T1.[TUV_DATE], T1.[TUV_INSP], T1.[ASU_TYPE], T1.[ASU_DATE], T1.[ASU_INSP], T1.[TYPE_YEAR], T1.[PACKAGE_CF], T1.[VEH_ASS_TYPE], T1.[SALE_THIS_YEAR], T1.[SALE_LAST_YEAR], T1.[SALE_LAST_YEAR_1], T1.[DELETE_PROPOSAL], T1.[DUPLICATE_REG_NO], T1.[LEASING], T1.[SHIP_DATE], T1.[FAC_ORDER_NUMBER], T1.[AVAILABLE], T1.[CAL_COST], T1.[CAL_COST_DATE], T1.[RUN_1], T1.[RUN_2], T1.[RUN_3], T1.[RUN_4], T1.[RUN_5], T1.[RUN_6], T1.[RUN_7], T1.[RUN_8], T1.[RUN_9], T1.[RUN_10], T1.[RUN_11], T1.[RUN_12], T1.[RUN_13], T1.[RUN_14], T1.[RUN_15], T1.[RUN_16], T1.[RUN_17], T1.[RUN_18], T1.[RUN_19], T1.[RUN_20], T1.[STOCK_DATE], T1.[MARKING_1], T1.[MARKING_2], T1.[MARKING_3], T1.[MARKING_4], T1.[MARKING_5], T1.[IMP_ORDER_NUMBER], T1.[SCRAP_DATE], T1.[TRANSMISSION_DATE], T1.[PURCH_CAL_DATE], T1.[SALES_CAL_DATE], T1.[DEALER_DEL_DATE], T1.[OPTIONAL_DATE_1], T1.[OPTIONAL_DATE_2], T1.[OPTIONAL_DATE_3], T1.[OPTIONAL_DATE_4], T1.[OPTIONAL_DATE_5], T1.[MODEL_LINE_GROUP], T1.[MODEL_TYPE_2], T1.[MAKE], T1.[HOUR_RATE_TABLE], T1.[PAID_DATE], T1.[LATEST_INV_DATE], T1.[ORIG_INV_DATE], T1.[CREDIT_NOTE_DATE], T1.[EXTRACTION_DATE], T1.[PROD_INFO], T1.[REG_NUMBER_IMP], T1.[PRICE_CARD], T1.[PURCH_AMOUNT], T1.[DEALER_NUMBER], T1.[INVOICE_STATE], T1.[VEH_DUE_DATE], T1.[DEALER_MARKING], T1.[TRADE_IN_CAR], T1.[TRADE_IN_CAR_YEAR], T1.[EXPORT_VEHICLE], T1.[DOORS], T1.[KBA_CODE], T1.[FUELTYPE], T1.[FUEL_CONS_TOWN], T1.[FUEL_CONS_90KMH], T1.[FUEL_CONS_EUNORM], T1.[CALL_FOR_SERVICE], T1.[EXP_KM_PER_YEAR], T1.[EXP_SERVICE_DATE_1], T1.[EXP_SERVICE_DATE_2], T1.[EXP_SERVICE_DATE_3], T1.[EXP_SERVICE_DATE_4], T1.[EXP_SERVICE_DATE_5], T1.[DEALER_MESSAGE_NO], T1.[SERVICE_DAYS], T1.[HOURLY_REPAIR_RATE], T1.[WORKSHOP_PRICECODE], T1.[DISCOUNT_PERC_WORK], T1.[SOLDMARK_DATE], T1.[MOBIL_SC_DATE], T1.[TYPE_CER_TXT], T1.[MAKE_CD], T1.[VEH_LOCATION], T1.[IMP_COMMENT], T1.[DEALER_NOTE], T1.[DELIVER_TO_DEALER], T1.[TRADE_IN_CAR_CHAS], T1.[GMS_REFERENCE], T1.[USE_OF_VEHICLE], T1.[PAINT_TYPE], T1.[GEAR_NO], T1.[SERV_CONTRACT_NO], T1.[PRODUCTION_NO], T1.[PHOTO], T1.[UPLOAD_MARKING], T1.[DOOR_CODE], T1.[BPM_AMOUNT], T1.[RADIO_CODE], T1.[WARRENTY_END], T1.[LAST_MOT_DATE], T1.[LAST_SERVICE_DATE], T1.[LAST_SERVICE_TXT], T1.[REPLACEMENT_DATE], T1.[NEXT_SERVICE_TXT], T1.[MAINTAIN_INT_YEARS], T1.[MAINTAIN_INT_MILES], T1.[SALES_LOCATION], T1.[SERVICE_LOCATION], T1.[FISCAL_HORSEPOWER], T1.[EXPORT_EUROCASION], T1.[HORSEPOWER], T1.[GOV_CERT_REQUEST_DATE], T1.[GOV_CERT_RECEPTION_DATE], T1.[HANDLER_SYSTEM], T1.[ENGINE_HOURS], T1.[LICENCE_LOCATION], T1.[MD_MACHINE_ID], T1.[CHASSIS_UNIQUE], T1.[COURTESY_CAR], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], '1' as [Client_DB] FROM [deop01].[dbo].[VEHICLE] T1  WHERE 1 = 1 ORDER BY T1.[timestamp] "
  call bcp_in.bat "VEHICLE_1" "[import].[VEHICLE]" "OPTIMA"
rem Nur in Quelle: REG_NUMBER_SEARCH
  call bcp_queryout.bat "VEHICLE_2" "SELECT T1.[BASIS_NUMBER], T1.[STATE_CODE_CF], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[DEBIT_ACCOUNT], T1.[REGISTER_NUMBER], T1.[CHASSIS_NUMBER], T1.[CAR_GROUP], T1.[CAR_STATUS], T1.[FAC_MODEL_CODE_L], T1.[USER_CODE], T1.[OWNER_CODE], T1.[UNIT_ACCOUNTING_CF], T1.[CONTACT_PERSON], T1.[FIRST_REG_DATE], T1.[LATEST_REG_DATE], T1.[FIRST_OCCUR_DATE], T1.[EXPECTED_ARR_DATE], T1.[ARRIVAL_DATE], T1.[LAST_OWNER_CHANGE], T1.[SALESMAN_BUY], T1.[SALESMAN_SALE], T1.[MODEL_TEXT], T1.[ORIG_MODEL_CODE1], T1.[ORIG_MODEL_CODE2], T1.[COLOUR_CF], T1.[TRIM_TXT], T1.[MODEL_LINE], T1.[WORKSHOP_MODEL], T1.[FAC_MODEL_CODE_S], T1.[CLASSIFICATION], T1.[MOTOR_NUMBER], T1.[KEY_CODE], T1.[YEAR_MODEL_CF], T1.[CYLINDER_VOLUME], T1.[SEATS], T1.[DECLARATION_DATE], T1.[DECLARATION_PLACE], T1.[DECLARATION_NUMBER], T1.[ARRIVAL_SHIP], T1.[ARRIVAL_NUMBER], T1.[BILL_OF_LANDING], T1.[SCRUTINEERING_DATE], T1.[EQUIPMENT_1], T1.[EQUIPMENT_2], T1.[EQUIPMENT_3], T1.[EQUIPMENT_4], T1.[INSURANCE], T1.[INSURANCE_COMPANY], T1.[MILEAGE], T1.[MISC_1_CF], T1.[MISC_2_CF], T1.[MISC_3_CF], T1.[MISC_4_CF], T1.[MISC_5_CF], T1.[MISC_6_CF], T1.[MISC_7_CF], T1.[MISC_8_CF], T1.[MISC_9_CF], T1.[MISC_10_CF], T1.[LAST_INVOICE_DTE], T1.[CONTACT_DATE], T1.[MAIL_CODE_1], T1.[MAIL_CODE_2], T1.[MAIL_CODE_3], T1.[MAIL_CODE_4], T1.[MAIL_CODE_5], T1.[MAIL_CODE_6], T1.[MAIL_CODE_7], T1.[MAIL_CODE_8], T1.[MAIL_CODE_9], T1.[MOTOR_CODE], T1.[GEAR_CODE], T1.[DRIVE_CODE], T1.[COLOUR_CODE], T1.[TRIM_CODE], T1.[LATEST_UNIT_NO], T1.[FOLLOW_UP], T1.[NO_OF_OWNERS], T1.[CAR_LETTER], T1.[TUV_TYPE], T1.[TUV_DATE], T1.[TUV_INSP], T1.[ASU_TYPE], T1.[ASU_DATE], T1.[ASU_INSP], T1.[TYPE_YEAR], T1.[PACKAGE_CF], T1.[VEH_ASS_TYPE], T1.[SALE_THIS_YEAR], T1.[SALE_LAST_YEAR], T1.[SALE_LAST_YEAR_1], T1.[DELETE_PROPOSAL], T1.[DUPLICATE_REG_NO], T1.[LEASING], T1.[SHIP_DATE], T1.[FAC_ORDER_NUMBER], T1.[AVAILABLE], T1.[CAL_COST], T1.[CAL_COST_DATE], T1.[RUN_1], T1.[RUN_2], T1.[RUN_3], T1.[RUN_4], T1.[RUN_5], T1.[RUN_6], T1.[RUN_7], T1.[RUN_8], T1.[RUN_9], T1.[RUN_10], T1.[RUN_11], T1.[RUN_12], T1.[RUN_13], T1.[RUN_14], T1.[RUN_15], T1.[RUN_16], T1.[RUN_17], T1.[RUN_18], T1.[RUN_19], T1.[RUN_20], T1.[STOCK_DATE], T1.[MARKING_1], T1.[MARKING_2], T1.[MARKING_3], T1.[MARKING_4], T1.[MARKING_5], T1.[IMP_ORDER_NUMBER], T1.[SCRAP_DATE], T1.[TRANSMISSION_DATE], T1.[PURCH_CAL_DATE], T1.[SALES_CAL_DATE], T1.[DEALER_DEL_DATE], T1.[OPTIONAL_DATE_1], T1.[OPTIONAL_DATE_2], T1.[OPTIONAL_DATE_3], T1.[OPTIONAL_DATE_4], T1.[OPTIONAL_DATE_5], T1.[MODEL_LINE_GROUP], T1.[MODEL_TYPE_2], T1.[MAKE], T1.[HOUR_RATE_TABLE], T1.[PAID_DATE], T1.[LATEST_INV_DATE], T1.[ORIG_INV_DATE], T1.[CREDIT_NOTE_DATE], T1.[EXTRACTION_DATE], T1.[PROD_INFO], T1.[REG_NUMBER_IMP], T1.[PRICE_CARD], T1.[PURCH_AMOUNT], T1.[DEALER_NUMBER], T1.[INVOICE_STATE], T1.[VEH_DUE_DATE], T1.[DEALER_MARKING], T1.[TRADE_IN_CAR], T1.[TRADE_IN_CAR_YEAR], T1.[EXPORT_VEHICLE], T1.[DOORS], T1.[KBA_CODE], T1.[FUELTYPE], T1.[FUEL_CONS_TOWN], T1.[FUEL_CONS_90KMH], T1.[FUEL_CONS_EUNORM], T1.[CALL_FOR_SERVICE], T1.[EXP_KM_PER_YEAR], T1.[EXP_SERVICE_DATE_1], T1.[EXP_SERVICE_DATE_2], T1.[EXP_SERVICE_DATE_3], T1.[EXP_SERVICE_DATE_4], T1.[EXP_SERVICE_DATE_5], T1.[DEALER_MESSAGE_NO], T1.[SERVICE_DAYS], T1.[HOURLY_REPAIR_RATE], T1.[WORKSHOP_PRICECODE], T1.[DISCOUNT_PERC_WORK], T1.[SOLDMARK_DATE], T1.[MOBIL_SC_DATE], T1.[TYPE_CER_TXT], T1.[MAKE_CD], T1.[VEH_LOCATION], T1.[IMP_COMMENT], T1.[DEALER_NOTE], T1.[DELIVER_TO_DEALER], T1.[TRADE_IN_CAR_CHAS], T1.[GMS_REFERENCE], T1.[USE_OF_VEHICLE], T1.[PAINT_TYPE], T1.[GEAR_NO], T1.[SERV_CONTRACT_NO], T1.[PRODUCTION_NO], T1.[PHOTO], T1.[UPLOAD_MARKING], T1.[DOOR_CODE], T1.[BPM_AMOUNT], T1.[RADIO_CODE], T1.[WARRENTY_END], T1.[LAST_MOT_DATE], T1.[LAST_SERVICE_DATE], T1.[LAST_SERVICE_TXT], T1.[REPLACEMENT_DATE], T1.[NEXT_SERVICE_TXT], T1.[MAINTAIN_INT_YEARS], T1.[MAINTAIN_INT_MILES], T1.[SALES_LOCATION], T1.[SERVICE_LOCATION], T1.[FISCAL_HORSEPOWER], T1.[EXPORT_EUROCASION], T1.[HORSEPOWER], T1.[GOV_CERT_REQUEST_DATE], T1.[GOV_CERT_RECEPTION_DATE], T1.[HANDLER_SYSTEM], T1.[ENGINE_HOURS], T1.[LICENCE_LOCATION], T1.[MD_MACHINE_ID], T1.[CHASSIS_UNIQUE], T1.[COURTESY_CAR], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], '2' as [Client_DB] FROM [deop02].[dbo].[VEHICLE] T1  WHERE 1 = 1 ORDER BY T1.[timestamp] "
  call bcp_in.bat "VEHICLE_2" "[import].[VEHICLE]" "OPTIMA"
  goto :cleanup

:increment
  call sql_query.bat "TRUNCATE TABLE [OPTIMAX].[temp].[VEHICLE]"

  call sql_timestamp.bat "VEHICLE_1" "[OPTIMA].[import].[VEHICLE]" "1"
  call bcp_queryout.bat "VEHICLE_1" "SELECT T1.[BASIS_NUMBER], T1.[STATE_CODE_CF], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[DEBIT_ACCOUNT], T1.[REGISTER_NUMBER], T1.[CHASSIS_NUMBER], T1.[CAR_GROUP], T1.[CAR_STATUS], T1.[FAC_MODEL_CODE_L], T1.[USER_CODE], T1.[OWNER_CODE], T1.[UNIT_ACCOUNTING_CF], T1.[CONTACT_PERSON], T1.[FIRST_REG_DATE], T1.[LATEST_REG_DATE], T1.[FIRST_OCCUR_DATE], T1.[EXPECTED_ARR_DATE], T1.[ARRIVAL_DATE], T1.[LAST_OWNER_CHANGE], T1.[SALESMAN_BUY], T1.[SALESMAN_SALE], T1.[MODEL_TEXT], T1.[ORIG_MODEL_CODE1], T1.[ORIG_MODEL_CODE2], T1.[COLOUR_CF], T1.[TRIM_TXT], T1.[MODEL_LINE], T1.[WORKSHOP_MODEL], T1.[FAC_MODEL_CODE_S], T1.[CLASSIFICATION], T1.[MOTOR_NUMBER], T1.[KEY_CODE], T1.[YEAR_MODEL_CF], T1.[CYLINDER_VOLUME], T1.[SEATS], T1.[DECLARATION_DATE], T1.[DECLARATION_PLACE], T1.[DECLARATION_NUMBER], T1.[ARRIVAL_SHIP], T1.[ARRIVAL_NUMBER], T1.[BILL_OF_LANDING], T1.[SCRUTINEERING_DATE], T1.[EQUIPMENT_1], T1.[EQUIPMENT_2], T1.[EQUIPMENT_3], T1.[EQUIPMENT_4], T1.[INSURANCE], T1.[INSURANCE_COMPANY], T1.[MILEAGE], T1.[MISC_1_CF], T1.[MISC_2_CF], T1.[MISC_3_CF], T1.[MISC_4_CF], T1.[MISC_5_CF], T1.[MISC_6_CF], T1.[MISC_7_CF], T1.[MISC_8_CF], T1.[MISC_9_CF], T1.[MISC_10_CF], T1.[LAST_INVOICE_DTE], T1.[CONTACT_DATE], T1.[MAIL_CODE_1], T1.[MAIL_CODE_2], T1.[MAIL_CODE_3], T1.[MAIL_CODE_4], T1.[MAIL_CODE_5], T1.[MAIL_CODE_6], T1.[MAIL_CODE_7], T1.[MAIL_CODE_8], T1.[MAIL_CODE_9], T1.[MOTOR_CODE], T1.[GEAR_CODE], T1.[DRIVE_CODE], T1.[COLOUR_CODE], T1.[TRIM_CODE], T1.[LATEST_UNIT_NO], T1.[FOLLOW_UP], T1.[NO_OF_OWNERS], T1.[CAR_LETTER], T1.[TUV_TYPE], T1.[TUV_DATE], T1.[TUV_INSP], T1.[ASU_TYPE], T1.[ASU_DATE], T1.[ASU_INSP], T1.[TYPE_YEAR], T1.[PACKAGE_CF], T1.[VEH_ASS_TYPE], T1.[SALE_THIS_YEAR], T1.[SALE_LAST_YEAR], T1.[SALE_LAST_YEAR_1], T1.[DELETE_PROPOSAL], T1.[DUPLICATE_REG_NO], T1.[LEASING], T1.[SHIP_DATE], T1.[FAC_ORDER_NUMBER], T1.[AVAILABLE], T1.[CAL_COST], T1.[CAL_COST_DATE], T1.[RUN_1], T1.[RUN_2], T1.[RUN_3], T1.[RUN_4], T1.[RUN_5], T1.[RUN_6], T1.[RUN_7], T1.[RUN_8], T1.[RUN_9], T1.[RUN_10], T1.[RUN_11], T1.[RUN_12], T1.[RUN_13], T1.[RUN_14], T1.[RUN_15], T1.[RUN_16], T1.[RUN_17], T1.[RUN_18], T1.[RUN_19], T1.[RUN_20], T1.[STOCK_DATE], T1.[MARKING_1], T1.[MARKING_2], T1.[MARKING_3], T1.[MARKING_4], T1.[MARKING_5], T1.[IMP_ORDER_NUMBER], T1.[SCRAP_DATE], T1.[TRANSMISSION_DATE], T1.[PURCH_CAL_DATE], T1.[SALES_CAL_DATE], T1.[DEALER_DEL_DATE], T1.[OPTIONAL_DATE_1], T1.[OPTIONAL_DATE_2], T1.[OPTIONAL_DATE_3], T1.[OPTIONAL_DATE_4], T1.[OPTIONAL_DATE_5], T1.[MODEL_LINE_GROUP], T1.[MODEL_TYPE_2], T1.[MAKE], T1.[HOUR_RATE_TABLE], T1.[PAID_DATE], T1.[LATEST_INV_DATE], T1.[ORIG_INV_DATE], T1.[CREDIT_NOTE_DATE], T1.[EXTRACTION_DATE], T1.[PROD_INFO], T1.[REG_NUMBER_IMP], T1.[PRICE_CARD], T1.[PURCH_AMOUNT], T1.[DEALER_NUMBER], T1.[INVOICE_STATE], T1.[VEH_DUE_DATE], T1.[DEALER_MARKING], T1.[TRADE_IN_CAR], T1.[TRADE_IN_CAR_YEAR], T1.[EXPORT_VEHICLE], T1.[DOORS], T1.[KBA_CODE], T1.[FUELTYPE], T1.[FUEL_CONS_TOWN], T1.[FUEL_CONS_90KMH], T1.[FUEL_CONS_EUNORM], T1.[CALL_FOR_SERVICE], T1.[EXP_KM_PER_YEAR], T1.[EXP_SERVICE_DATE_1], T1.[EXP_SERVICE_DATE_2], T1.[EXP_SERVICE_DATE_3], T1.[EXP_SERVICE_DATE_4], T1.[EXP_SERVICE_DATE_5], T1.[DEALER_MESSAGE_NO], T1.[SERVICE_DAYS], T1.[HOURLY_REPAIR_RATE], T1.[WORKSHOP_PRICECODE], T1.[DISCOUNT_PERC_WORK], T1.[SOLDMARK_DATE], T1.[MOBIL_SC_DATE], T1.[TYPE_CER_TXT], T1.[MAKE_CD], T1.[VEH_LOCATION], T1.[IMP_COMMENT], T1.[DEALER_NOTE], T1.[DELIVER_TO_DEALER], T1.[TRADE_IN_CAR_CHAS], T1.[GMS_REFERENCE], T1.[USE_OF_VEHICLE], T1.[PAINT_TYPE], T1.[GEAR_NO], T1.[SERV_CONTRACT_NO], T1.[PRODUCTION_NO], T1.[PHOTO], T1.[UPLOAD_MARKING], T1.[DOOR_CODE], T1.[BPM_AMOUNT], T1.[RADIO_CODE], T1.[WARRENTY_END], T1.[LAST_MOT_DATE], T1.[LAST_SERVICE_DATE], T1.[LAST_SERVICE_TXT], T1.[REPLACEMENT_DATE], T1.[NEXT_SERVICE_TXT], T1.[MAINTAIN_INT_YEARS], T1.[MAINTAIN_INT_MILES], T1.[SALES_LOCATION], T1.[SERVICE_LOCATION], T1.[FISCAL_HORSEPOWER], T1.[EXPORT_EUROCASION], T1.[HORSEPOWER], T1.[GOV_CERT_REQUEST_DATE], T1.[GOV_CERT_RECEPTION_DATE], T1.[HANDLER_SYSTEM], T1.[ENGINE_HOURS], T1.[LICENCE_LOCATION], T1.[MD_MACHINE_ID], T1.[CHASSIS_UNIQUE], T1.[COURTESY_CAR], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], '1' as [Client_DB] FROM [deop01].[dbo].[VEHICLE] T1  WHERE T1.[timestamp] > convert(binary(8), '%TS%', 1) AND 1 = 1 ORDER BY T1.[timestamp] "
  call bcp_in.bat "VEHICLE_1" "[temp].[VEHICLE]" "OPTIMAX"

  call sql_timestamp.bat "VEHICLE_2" "[OPTIMA].[import].[VEHICLE]" "2"
  call bcp_queryout.bat "VEHICLE_2" "SELECT T1.[BASIS_NUMBER], T1.[STATE_CODE_CF], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[DEBIT_ACCOUNT], T1.[REGISTER_NUMBER], T1.[CHASSIS_NUMBER], T1.[CAR_GROUP], T1.[CAR_STATUS], T1.[FAC_MODEL_CODE_L], T1.[USER_CODE], T1.[OWNER_CODE], T1.[UNIT_ACCOUNTING_CF], T1.[CONTACT_PERSON], T1.[FIRST_REG_DATE], T1.[LATEST_REG_DATE], T1.[FIRST_OCCUR_DATE], T1.[EXPECTED_ARR_DATE], T1.[ARRIVAL_DATE], T1.[LAST_OWNER_CHANGE], T1.[SALESMAN_BUY], T1.[SALESMAN_SALE], T1.[MODEL_TEXT], T1.[ORIG_MODEL_CODE1], T1.[ORIG_MODEL_CODE2], T1.[COLOUR_CF], T1.[TRIM_TXT], T1.[MODEL_LINE], T1.[WORKSHOP_MODEL], T1.[FAC_MODEL_CODE_S], T1.[CLASSIFICATION], T1.[MOTOR_NUMBER], T1.[KEY_CODE], T1.[YEAR_MODEL_CF], T1.[CYLINDER_VOLUME], T1.[SEATS], T1.[DECLARATION_DATE], T1.[DECLARATION_PLACE], T1.[DECLARATION_NUMBER], T1.[ARRIVAL_SHIP], T1.[ARRIVAL_NUMBER], T1.[BILL_OF_LANDING], T1.[SCRUTINEERING_DATE], T1.[EQUIPMENT_1], T1.[EQUIPMENT_2], T1.[EQUIPMENT_3], T1.[EQUIPMENT_4], T1.[INSURANCE], T1.[INSURANCE_COMPANY], T1.[MILEAGE], T1.[MISC_1_CF], T1.[MISC_2_CF], T1.[MISC_3_CF], T1.[MISC_4_CF], T1.[MISC_5_CF], T1.[MISC_6_CF], T1.[MISC_7_CF], T1.[MISC_8_CF], T1.[MISC_9_CF], T1.[MISC_10_CF], T1.[LAST_INVOICE_DTE], T1.[CONTACT_DATE], T1.[MAIL_CODE_1], T1.[MAIL_CODE_2], T1.[MAIL_CODE_3], T1.[MAIL_CODE_4], T1.[MAIL_CODE_5], T1.[MAIL_CODE_6], T1.[MAIL_CODE_7], T1.[MAIL_CODE_8], T1.[MAIL_CODE_9], T1.[MOTOR_CODE], T1.[GEAR_CODE], T1.[DRIVE_CODE], T1.[COLOUR_CODE], T1.[TRIM_CODE], T1.[LATEST_UNIT_NO], T1.[FOLLOW_UP], T1.[NO_OF_OWNERS], T1.[CAR_LETTER], T1.[TUV_TYPE], T1.[TUV_DATE], T1.[TUV_INSP], T1.[ASU_TYPE], T1.[ASU_DATE], T1.[ASU_INSP], T1.[TYPE_YEAR], T1.[PACKAGE_CF], T1.[VEH_ASS_TYPE], T1.[SALE_THIS_YEAR], T1.[SALE_LAST_YEAR], T1.[SALE_LAST_YEAR_1], T1.[DELETE_PROPOSAL], T1.[DUPLICATE_REG_NO], T1.[LEASING], T1.[SHIP_DATE], T1.[FAC_ORDER_NUMBER], T1.[AVAILABLE], T1.[CAL_COST], T1.[CAL_COST_DATE], T1.[RUN_1], T1.[RUN_2], T1.[RUN_3], T1.[RUN_4], T1.[RUN_5], T1.[RUN_6], T1.[RUN_7], T1.[RUN_8], T1.[RUN_9], T1.[RUN_10], T1.[RUN_11], T1.[RUN_12], T1.[RUN_13], T1.[RUN_14], T1.[RUN_15], T1.[RUN_16], T1.[RUN_17], T1.[RUN_18], T1.[RUN_19], T1.[RUN_20], T1.[STOCK_DATE], T1.[MARKING_1], T1.[MARKING_2], T1.[MARKING_3], T1.[MARKING_4], T1.[MARKING_5], T1.[IMP_ORDER_NUMBER], T1.[SCRAP_DATE], T1.[TRANSMISSION_DATE], T1.[PURCH_CAL_DATE], T1.[SALES_CAL_DATE], T1.[DEALER_DEL_DATE], T1.[OPTIONAL_DATE_1], T1.[OPTIONAL_DATE_2], T1.[OPTIONAL_DATE_3], T1.[OPTIONAL_DATE_4], T1.[OPTIONAL_DATE_5], T1.[MODEL_LINE_GROUP], T1.[MODEL_TYPE_2], T1.[MAKE], T1.[HOUR_RATE_TABLE], T1.[PAID_DATE], T1.[LATEST_INV_DATE], T1.[ORIG_INV_DATE], T1.[CREDIT_NOTE_DATE], T1.[EXTRACTION_DATE], T1.[PROD_INFO], T1.[REG_NUMBER_IMP], T1.[PRICE_CARD], T1.[PURCH_AMOUNT], T1.[DEALER_NUMBER], T1.[INVOICE_STATE], T1.[VEH_DUE_DATE], T1.[DEALER_MARKING], T1.[TRADE_IN_CAR], T1.[TRADE_IN_CAR_YEAR], T1.[EXPORT_VEHICLE], T1.[DOORS], T1.[KBA_CODE], T1.[FUELTYPE], T1.[FUEL_CONS_TOWN], T1.[FUEL_CONS_90KMH], T1.[FUEL_CONS_EUNORM], T1.[CALL_FOR_SERVICE], T1.[EXP_KM_PER_YEAR], T1.[EXP_SERVICE_DATE_1], T1.[EXP_SERVICE_DATE_2], T1.[EXP_SERVICE_DATE_3], T1.[EXP_SERVICE_DATE_4], T1.[EXP_SERVICE_DATE_5], T1.[DEALER_MESSAGE_NO], T1.[SERVICE_DAYS], T1.[HOURLY_REPAIR_RATE], T1.[WORKSHOP_PRICECODE], T1.[DISCOUNT_PERC_WORK], T1.[SOLDMARK_DATE], T1.[MOBIL_SC_DATE], T1.[TYPE_CER_TXT], T1.[MAKE_CD], T1.[VEH_LOCATION], T1.[IMP_COMMENT], T1.[DEALER_NOTE], T1.[DELIVER_TO_DEALER], T1.[TRADE_IN_CAR_CHAS], T1.[GMS_REFERENCE], T1.[USE_OF_VEHICLE], T1.[PAINT_TYPE], T1.[GEAR_NO], T1.[SERV_CONTRACT_NO], T1.[PRODUCTION_NO], T1.[PHOTO], T1.[UPLOAD_MARKING], T1.[DOOR_CODE], T1.[BPM_AMOUNT], T1.[RADIO_CODE], T1.[WARRENTY_END], T1.[LAST_MOT_DATE], T1.[LAST_SERVICE_DATE], T1.[LAST_SERVICE_TXT], T1.[REPLACEMENT_DATE], T1.[NEXT_SERVICE_TXT], T1.[MAINTAIN_INT_YEARS], T1.[MAINTAIN_INT_MILES], T1.[SALES_LOCATION], T1.[SERVICE_LOCATION], T1.[FISCAL_HORSEPOWER], T1.[EXPORT_EUROCASION], T1.[HORSEPOWER], T1.[GOV_CERT_REQUEST_DATE], T1.[GOV_CERT_RECEPTION_DATE], T1.[HANDLER_SYSTEM], T1.[ENGINE_HOURS], T1.[LICENCE_LOCATION], T1.[MD_MACHINE_ID], T1.[CHASSIS_UNIQUE], T1.[COURTESY_CAR], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], '2' as [Client_DB] FROM [deop02].[dbo].[VEHICLE] T1  WHERE T1.[timestamp] > convert(binary(8), '%TS%', 1) AND 1 = 1 ORDER BY T1.[timestamp] "
  call bcp_in.bat "VEHICLE_2" "[temp].[VEHICLE]" "OPTIMAX"

  call sql_query.bat "DELETE T1 FROM [OPTIMA].[import].[VEHICLE] T1 INNER JOIN [OPTIMAX].[temp].[VEHICLE] T2 ON T1.[CLIENT_DB] = T2.[CLIENT_DB] AND T1.[UNIQUE_IDENT] = T2.[UNIQUE_IDENT]"
  call sql_query.bat "INSERT INTO [OPTIMA].[import].[VEHICLE] with (TABLOCK) SELECT * FROM [OPTIMAX].[temp].[VEHICLE] T1"

:cleanup
  call delete.bat "C:\GlobalCube\System\OPTIMA\SQL\temp\VEHICLE_1.csv"
  call delete.bat "C:\GlobalCube\System\OPTIMA\SQL\temp\VEHICLE_2.csv"