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

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

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

:full
  call sql_query.bat "TRUNCATE TABLE [OPTIMA].[import].[PRODUCT_FILE]"
rem Nur in Quelle: ICE_ADHESION;SKR51_COST_BEARER;CL_REPL_FACTOR;SNOW_GRIP;PROD_CODE_SEARCH;CL_REPLACMENT_NO;EAN_NUMBER
  call bcp_queryout.bat "PRODUCT_FILE_1" "SELECT T1.[PRODUCT_GROUP], T1.[PROD_SORT_CODE], T1.[PROD_CODE], T1.[MAKE_CD], T1.[STATE_CODE_PARTS], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[PROD_NAME], T1.[FOREIGN_NAME], T1.[TAX_CODE_1], T1.[RE_PURCHASE_PRICE], T1.[LATEST_PURCH_PRICE], T1.[AVERAGE_PRICE], T1.[PRICE_A], T1.[PRICE_B], T1.[WEIGHT], T1.[QUANTITY_DISC_CODE], T1.[CAMPAIGN_CODE], T1.[PART_GROUP], T1.[ADD_COST_CODE], T1.[REPLACING_PROD], T1.[REPLACING_MAKE_CD], T1.[REPLACE_CODE], T1.[VAT_RATE_CODE], T1.[PROD_TYPE], T1.[STATISTIC_CODE], T1.[DEDUCTABLE], T1.[DISCOUNT_TABLE], T1.[DISCOUNT_CODE], T1.[DISCOUNT_CODE1], T1.[GROSS_DISCOUNT], T1.[CALCULATION_CODE], T1.[PRICE_C], T1.[SALES_PRICE], T1.[PRICE_CHANGE_DATE], T1.[SALES_UNIT], T1.[DECIMAL_INDICATOR], T1.[SUPPLIER_CODE], T1.[PERIODICAL_INDEX], T1.[PACKAGE], T1.[PURCHASE_UNIT], T1.[PRICE_T], T1.[CUSTOM_CODE], T1.[DUTY_GROUP], T1.[COUNTRY], T1.[CURRENCY], T1.[EXRATE], T1.[COST_PERC], T1.[NEXT_LINE], T1.[CREATION_DATE], T1.[SERVICE_LEVEL], T1.[MISC_1], T1.[MISC_2], T1.[MISC_3], T1.[PRICE_D], T1.[PRICE_E], T1.[PRICE_F], T1.[PRICE_G], T1.[CAMPAIN_PRICE], T1.[PRICE_U], T1.[PRICE_V], T1.[PURCHASE_LABELS], T1.[CLAIM_RETURN_CODE], T1.[SUPPLIER_1], T1.[SUPPLIER_2], T1.[SUPPLIER_3], T1.[PURCH_DISC_CODE], T1.[PRODS_NAME_L2], T1.[PRODS_NAME_L3], T1.[DELIVERY_TIME_PR], T1.[TARIFF_NUMBER], T1.[OLD_PROD_CODE], T1.[OLD_MAKE_CD], T1.[REPL_DATE], T1.[MISC_4], T1.[MISC_5], T1.[MISC_6], T1.[FAMILY_CODE], T1.[VOL_BONUS_IND], T1.[PACKAGE_USAGE], T1.[PNC_ALLOWANCE], T1.[DESCR_LEXICON_CODE], T1.[EXCH_PART_EUROCODE], T1.[LOWEST_PURCH_PRICE], T1.[LOWEST_PU_PR_DATE], T1.[CONSIGNMENT_CODE], T1.[CATALOGUE_NO], T1.[GMPD_CD], T1.[GMPD_SUB_CD], T1.[EFFECTIVE_DATE], T1.[VALID_TIME_START], T1.[VALID_TIME_END], T1.[KEY_CUT_IDC], T1.[DISPOSAL_IDC], T1.[DISPOSAL_GRP], T1.[GUARANTEE_ACTION], T1.[DANGER_GOODS_IDC], T1.[DANGER_GOODS_CD], T1.[MAIN_WAREHOUSE_CD], T1.[ORIGINAL_COUNTRY], T1.[LENGTH], T1.[WIDTH], T1.[HEIGHT], T1.[MEASURE_UNIT], T1.[UNIT_VOLUME], T1.[DURABILITY], T1.[SALES_LIFE], T1.[PALLET_TYPE], T1.[PALLET_QTY], T1.[CARTON_TYPE], T1.[CARTON_QTY], T1.[INNERPACK_TYPE], T1.[INNERPACK_QTY], T1.[BONUS_CD], T1.[RUSH_SURCHARGE_IDC], T1.[VOR_SURCHARGE_IDC], T1.[DISCOUNT_IDC_1], T1.[DISCOUNT_IDC_2], T1.[DISCOUNT_IDC_3], T1.[DISCOUNT_IDC_4], T1.[DISCOUNT_IDC_5], T1.[DISCOUNT_IDC_6], T1.[FACTORY_REPL_CD], T1.[AVERAGE_PRICE_YEAR], T1.[DEPOSIT], T1.[LUBRICANT], T1.[STANDARD_UNIT], T1.[UNIT_CONVERSION_SALES], T1.[UNIT_CONVERSION_PURCH], T1.[OIL], T1.[EXCHANGE_PART], T1.[MAKE_CD_CORE], T1.[PROD_CODE_CORE], T1.[SKIP_PRICE_CORR], T1.[BULKY_PART], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], T1.[CHASSISNO_ON_PURCH], T1.[GM_PART_NUMBER], T1.[QUANTITY_OF_SERVICES], T1.[PRICE_FACTOR], T1.[SPECIAL_ORDER_ITEM], T1.[FUEL_EFFICIENCY_CLASS], T1.[MANUALLY_CREATED], T1.[NOISE_CLASS], T1.[NOISE_RATE], T1.[PART_DESCRIPTION_CODE], T1.[PART_DESCRIPTION_EXTRACTED], T1.[PRODUCT_TYPE], T1.[TYRE_CLASS], T1.[WEET_GRIP_CLASS], T1.[PROD_NAME_200], T1.[MIN_ORDER_QTY], T1.[MODELS], T1.[PART_RETURNABLE_FLAG], T1.[PART_SIZE_CODE], T1.[PART_STATUS_CD], T1.[PMP_CD], T1.[TECHNICAL_BLOCK], T1.[ORIGINAL_PART], T1.[SARA_PART], '1' as [Client_DB] FROM [deop01].[dbo].[PRODUCT_FILE] T1  WHERE 1 = 1 ORDER BY T1.[timestamp] "
  call bcp_in.bat "PRODUCT_FILE_1" "[import].[PRODUCT_FILE]" "OPTIMA"
rem Nur in Quelle: ICE_ADHESION;SKR51_COST_BEARER;CL_REPL_FACTOR;SNOW_GRIP;PROD_CODE_SEARCH;CL_REPLACMENT_NO;EAN_NUMBER
  call bcp_queryout.bat "PRODUCT_FILE_2" "SELECT T1.[PRODUCT_GROUP], T1.[PROD_SORT_CODE], T1.[PROD_CODE], T1.[MAKE_CD], T1.[STATE_CODE_PARTS], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[PROD_NAME], T1.[FOREIGN_NAME], T1.[TAX_CODE_1], T1.[RE_PURCHASE_PRICE], T1.[LATEST_PURCH_PRICE], T1.[AVERAGE_PRICE], T1.[PRICE_A], T1.[PRICE_B], T1.[WEIGHT], T1.[QUANTITY_DISC_CODE], T1.[CAMPAIGN_CODE], T1.[PART_GROUP], T1.[ADD_COST_CODE], T1.[REPLACING_PROD], T1.[REPLACING_MAKE_CD], T1.[REPLACE_CODE], T1.[VAT_RATE_CODE], T1.[PROD_TYPE], T1.[STATISTIC_CODE], T1.[DEDUCTABLE], T1.[DISCOUNT_TABLE], T1.[DISCOUNT_CODE], T1.[DISCOUNT_CODE1], T1.[GROSS_DISCOUNT], T1.[CALCULATION_CODE], T1.[PRICE_C], T1.[SALES_PRICE], T1.[PRICE_CHANGE_DATE], T1.[SALES_UNIT], T1.[DECIMAL_INDICATOR], T1.[SUPPLIER_CODE], T1.[PERIODICAL_INDEX], T1.[PACKAGE], T1.[PURCHASE_UNIT], T1.[PRICE_T], T1.[CUSTOM_CODE], T1.[DUTY_GROUP], T1.[COUNTRY], T1.[CURRENCY], T1.[EXRATE], T1.[COST_PERC], T1.[NEXT_LINE], T1.[CREATION_DATE], T1.[SERVICE_LEVEL], T1.[MISC_1], T1.[MISC_2], T1.[MISC_3], T1.[PRICE_D], T1.[PRICE_E], T1.[PRICE_F], T1.[PRICE_G], T1.[CAMPAIN_PRICE], T1.[PRICE_U], T1.[PRICE_V], T1.[PURCHASE_LABELS], T1.[CLAIM_RETURN_CODE], T1.[SUPPLIER_1], T1.[SUPPLIER_2], T1.[SUPPLIER_3], T1.[PURCH_DISC_CODE], T1.[PRODS_NAME_L2], T1.[PRODS_NAME_L3], T1.[DELIVERY_TIME_PR], T1.[TARIFF_NUMBER], T1.[OLD_PROD_CODE], T1.[OLD_MAKE_CD], T1.[REPL_DATE], T1.[MISC_4], T1.[MISC_5], T1.[MISC_6], T1.[FAMILY_CODE], T1.[VOL_BONUS_IND], T1.[PACKAGE_USAGE], T1.[PNC_ALLOWANCE], T1.[DESCR_LEXICON_CODE], T1.[EXCH_PART_EUROCODE], T1.[LOWEST_PURCH_PRICE], T1.[LOWEST_PU_PR_DATE], T1.[CONSIGNMENT_CODE], T1.[CATALOGUE_NO], T1.[GMPD_CD], T1.[GMPD_SUB_CD], T1.[EFFECTIVE_DATE], T1.[VALID_TIME_START], T1.[VALID_TIME_END], T1.[KEY_CUT_IDC], T1.[DISPOSAL_IDC], T1.[DISPOSAL_GRP], T1.[GUARANTEE_ACTION], T1.[DANGER_GOODS_IDC], T1.[DANGER_GOODS_CD], T1.[MAIN_WAREHOUSE_CD], T1.[ORIGINAL_COUNTRY], T1.[LENGTH], T1.[WIDTH], T1.[HEIGHT], T1.[MEASURE_UNIT], T1.[UNIT_VOLUME], T1.[DURABILITY], T1.[SALES_LIFE], T1.[PALLET_TYPE], T1.[PALLET_QTY], T1.[CARTON_TYPE], T1.[CARTON_QTY], T1.[INNERPACK_TYPE], T1.[INNERPACK_QTY], T1.[BONUS_CD], T1.[RUSH_SURCHARGE_IDC], T1.[VOR_SURCHARGE_IDC], T1.[DISCOUNT_IDC_1], T1.[DISCOUNT_IDC_2], T1.[DISCOUNT_IDC_3], T1.[DISCOUNT_IDC_4], T1.[DISCOUNT_IDC_5], T1.[DISCOUNT_IDC_6], T1.[FACTORY_REPL_CD], T1.[AVERAGE_PRICE_YEAR], T1.[DEPOSIT], T1.[LUBRICANT], T1.[STANDARD_UNIT], T1.[UNIT_CONVERSION_SALES], T1.[UNIT_CONVERSION_PURCH], T1.[OIL], T1.[EXCHANGE_PART], T1.[MAKE_CD_CORE], T1.[PROD_CODE_CORE], T1.[SKIP_PRICE_CORR], T1.[BULKY_PART], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], T1.[CHASSISNO_ON_PURCH], T1.[GM_PART_NUMBER], T1.[QUANTITY_OF_SERVICES], T1.[PRICE_FACTOR], T1.[SPECIAL_ORDER_ITEM], T1.[FUEL_EFFICIENCY_CLASS], T1.[MANUALLY_CREATED], T1.[NOISE_CLASS], T1.[NOISE_RATE], T1.[PART_DESCRIPTION_CODE], T1.[PART_DESCRIPTION_EXTRACTED], T1.[PRODUCT_TYPE], T1.[TYRE_CLASS], T1.[WEET_GRIP_CLASS], T1.[PROD_NAME_200], T1.[MIN_ORDER_QTY], T1.[MODELS], T1.[PART_RETURNABLE_FLAG], T1.[PART_SIZE_CODE], T1.[PART_STATUS_CD], T1.[PMP_CD], T1.[TECHNICAL_BLOCK], T1.[ORIGINAL_PART], T1.[SARA_PART], '2' as [Client_DB] FROM [deop02].[dbo].[PRODUCT_FILE] T1  WHERE 1 = 1 ORDER BY T1.[timestamp] "
  call bcp_in.bat "PRODUCT_FILE_2" "[import].[PRODUCT_FILE]" "OPTIMA"
  goto :cleanup

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

  call sql_timestamp.bat "PRODUCT_FILE_1" "[OPTIMA].[import].[PRODUCT_FILE]" "1"
  call bcp_queryout.bat "PRODUCT_FILE_1" "SELECT T1.[PRODUCT_GROUP], T1.[PROD_SORT_CODE], T1.[PROD_CODE], T1.[MAKE_CD], T1.[STATE_CODE_PARTS], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[PROD_NAME], T1.[FOREIGN_NAME], T1.[TAX_CODE_1], T1.[RE_PURCHASE_PRICE], T1.[LATEST_PURCH_PRICE], T1.[AVERAGE_PRICE], T1.[PRICE_A], T1.[PRICE_B], T1.[WEIGHT], T1.[QUANTITY_DISC_CODE], T1.[CAMPAIGN_CODE], T1.[PART_GROUP], T1.[ADD_COST_CODE], T1.[REPLACING_PROD], T1.[REPLACING_MAKE_CD], T1.[REPLACE_CODE], T1.[VAT_RATE_CODE], T1.[PROD_TYPE], T1.[STATISTIC_CODE], T1.[DEDUCTABLE], T1.[DISCOUNT_TABLE], T1.[DISCOUNT_CODE], T1.[DISCOUNT_CODE1], T1.[GROSS_DISCOUNT], T1.[CALCULATION_CODE], T1.[PRICE_C], T1.[SALES_PRICE], T1.[PRICE_CHANGE_DATE], T1.[SALES_UNIT], T1.[DECIMAL_INDICATOR], T1.[SUPPLIER_CODE], T1.[PERIODICAL_INDEX], T1.[PACKAGE], T1.[PURCHASE_UNIT], T1.[PRICE_T], T1.[CUSTOM_CODE], T1.[DUTY_GROUP], T1.[COUNTRY], T1.[CURRENCY], T1.[EXRATE], T1.[COST_PERC], T1.[NEXT_LINE], T1.[CREATION_DATE], T1.[SERVICE_LEVEL], T1.[MISC_1], T1.[MISC_2], T1.[MISC_3], T1.[PRICE_D], T1.[PRICE_E], T1.[PRICE_F], T1.[PRICE_G], T1.[CAMPAIN_PRICE], T1.[PRICE_U], T1.[PRICE_V], T1.[PURCHASE_LABELS], T1.[CLAIM_RETURN_CODE], T1.[SUPPLIER_1], T1.[SUPPLIER_2], T1.[SUPPLIER_3], T1.[PURCH_DISC_CODE], T1.[PRODS_NAME_L2], T1.[PRODS_NAME_L3], T1.[DELIVERY_TIME_PR], T1.[TARIFF_NUMBER], T1.[OLD_PROD_CODE], T1.[OLD_MAKE_CD], T1.[REPL_DATE], T1.[MISC_4], T1.[MISC_5], T1.[MISC_6], T1.[FAMILY_CODE], T1.[VOL_BONUS_IND], T1.[PACKAGE_USAGE], T1.[PNC_ALLOWANCE], T1.[DESCR_LEXICON_CODE], T1.[EXCH_PART_EUROCODE], T1.[LOWEST_PURCH_PRICE], T1.[LOWEST_PU_PR_DATE], T1.[CONSIGNMENT_CODE], T1.[CATALOGUE_NO], T1.[GMPD_CD], T1.[GMPD_SUB_CD], T1.[EFFECTIVE_DATE], T1.[VALID_TIME_START], T1.[VALID_TIME_END], T1.[KEY_CUT_IDC], T1.[DISPOSAL_IDC], T1.[DISPOSAL_GRP], T1.[GUARANTEE_ACTION], T1.[DANGER_GOODS_IDC], T1.[DANGER_GOODS_CD], T1.[MAIN_WAREHOUSE_CD], T1.[ORIGINAL_COUNTRY], T1.[LENGTH], T1.[WIDTH], T1.[HEIGHT], T1.[MEASURE_UNIT], T1.[UNIT_VOLUME], T1.[DURABILITY], T1.[SALES_LIFE], T1.[PALLET_TYPE], T1.[PALLET_QTY], T1.[CARTON_TYPE], T1.[CARTON_QTY], T1.[INNERPACK_TYPE], T1.[INNERPACK_QTY], T1.[BONUS_CD], T1.[RUSH_SURCHARGE_IDC], T1.[VOR_SURCHARGE_IDC], T1.[DISCOUNT_IDC_1], T1.[DISCOUNT_IDC_2], T1.[DISCOUNT_IDC_3], T1.[DISCOUNT_IDC_4], T1.[DISCOUNT_IDC_5], T1.[DISCOUNT_IDC_6], T1.[FACTORY_REPL_CD], T1.[AVERAGE_PRICE_YEAR], T1.[DEPOSIT], T1.[LUBRICANT], T1.[STANDARD_UNIT], T1.[UNIT_CONVERSION_SALES], T1.[UNIT_CONVERSION_PURCH], T1.[OIL], T1.[EXCHANGE_PART], T1.[MAKE_CD_CORE], T1.[PROD_CODE_CORE], T1.[SKIP_PRICE_CORR], T1.[BULKY_PART], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], T1.[CHASSISNO_ON_PURCH], T1.[GM_PART_NUMBER], T1.[QUANTITY_OF_SERVICES], T1.[PRICE_FACTOR], T1.[SPECIAL_ORDER_ITEM], T1.[FUEL_EFFICIENCY_CLASS], T1.[MANUALLY_CREATED], T1.[NOISE_CLASS], T1.[NOISE_RATE], T1.[PART_DESCRIPTION_CODE], T1.[PART_DESCRIPTION_EXTRACTED], T1.[PRODUCT_TYPE], T1.[TYRE_CLASS], T1.[WEET_GRIP_CLASS], T1.[PROD_NAME_200], T1.[MIN_ORDER_QTY], T1.[MODELS], T1.[PART_RETURNABLE_FLAG], T1.[PART_SIZE_CODE], T1.[PART_STATUS_CD], T1.[PMP_CD], T1.[TECHNICAL_BLOCK], T1.[ORIGINAL_PART], T1.[SARA_PART], '1' as [Client_DB] FROM [deop01].[dbo].[PRODUCT_FILE] T1  WHERE T1.[timestamp] > convert(binary(8), '%TS%', 1) AND 1 = 1 ORDER BY T1.[timestamp] "
  call bcp_in.bat "PRODUCT_FILE_1" "[temp].[PRODUCT_FILE]" "OPTIMAX"

  call sql_timestamp.bat "PRODUCT_FILE_2" "[OPTIMA].[import].[PRODUCT_FILE]" "2"
  call bcp_queryout.bat "PRODUCT_FILE_2" "SELECT T1.[PRODUCT_GROUP], T1.[PROD_SORT_CODE], T1.[PROD_CODE], T1.[MAKE_CD], T1.[STATE_CODE_PARTS], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[PROD_NAME], T1.[FOREIGN_NAME], T1.[TAX_CODE_1], T1.[RE_PURCHASE_PRICE], T1.[LATEST_PURCH_PRICE], T1.[AVERAGE_PRICE], T1.[PRICE_A], T1.[PRICE_B], T1.[WEIGHT], T1.[QUANTITY_DISC_CODE], T1.[CAMPAIGN_CODE], T1.[PART_GROUP], T1.[ADD_COST_CODE], T1.[REPLACING_PROD], T1.[REPLACING_MAKE_CD], T1.[REPLACE_CODE], T1.[VAT_RATE_CODE], T1.[PROD_TYPE], T1.[STATISTIC_CODE], T1.[DEDUCTABLE], T1.[DISCOUNT_TABLE], T1.[DISCOUNT_CODE], T1.[DISCOUNT_CODE1], T1.[GROSS_DISCOUNT], T1.[CALCULATION_CODE], T1.[PRICE_C], T1.[SALES_PRICE], T1.[PRICE_CHANGE_DATE], T1.[SALES_UNIT], T1.[DECIMAL_INDICATOR], T1.[SUPPLIER_CODE], T1.[PERIODICAL_INDEX], T1.[PACKAGE], T1.[PURCHASE_UNIT], T1.[PRICE_T], T1.[CUSTOM_CODE], T1.[DUTY_GROUP], T1.[COUNTRY], T1.[CURRENCY], T1.[EXRATE], T1.[COST_PERC], T1.[NEXT_LINE], T1.[CREATION_DATE], T1.[SERVICE_LEVEL], T1.[MISC_1], T1.[MISC_2], T1.[MISC_3], T1.[PRICE_D], T1.[PRICE_E], T1.[PRICE_F], T1.[PRICE_G], T1.[CAMPAIN_PRICE], T1.[PRICE_U], T1.[PRICE_V], T1.[PURCHASE_LABELS], T1.[CLAIM_RETURN_CODE], T1.[SUPPLIER_1], T1.[SUPPLIER_2], T1.[SUPPLIER_3], T1.[PURCH_DISC_CODE], T1.[PRODS_NAME_L2], T1.[PRODS_NAME_L3], T1.[DELIVERY_TIME_PR], T1.[TARIFF_NUMBER], T1.[OLD_PROD_CODE], T1.[OLD_MAKE_CD], T1.[REPL_DATE], T1.[MISC_4], T1.[MISC_5], T1.[MISC_6], T1.[FAMILY_CODE], T1.[VOL_BONUS_IND], T1.[PACKAGE_USAGE], T1.[PNC_ALLOWANCE], T1.[DESCR_LEXICON_CODE], T1.[EXCH_PART_EUROCODE], T1.[LOWEST_PURCH_PRICE], T1.[LOWEST_PU_PR_DATE], T1.[CONSIGNMENT_CODE], T1.[CATALOGUE_NO], T1.[GMPD_CD], T1.[GMPD_SUB_CD], T1.[EFFECTIVE_DATE], T1.[VALID_TIME_START], T1.[VALID_TIME_END], T1.[KEY_CUT_IDC], T1.[DISPOSAL_IDC], T1.[DISPOSAL_GRP], T1.[GUARANTEE_ACTION], T1.[DANGER_GOODS_IDC], T1.[DANGER_GOODS_CD], T1.[MAIN_WAREHOUSE_CD], T1.[ORIGINAL_COUNTRY], T1.[LENGTH], T1.[WIDTH], T1.[HEIGHT], T1.[MEASURE_UNIT], T1.[UNIT_VOLUME], T1.[DURABILITY], T1.[SALES_LIFE], T1.[PALLET_TYPE], T1.[PALLET_QTY], T1.[CARTON_TYPE], T1.[CARTON_QTY], T1.[INNERPACK_TYPE], T1.[INNERPACK_QTY], T1.[BONUS_CD], T1.[RUSH_SURCHARGE_IDC], T1.[VOR_SURCHARGE_IDC], T1.[DISCOUNT_IDC_1], T1.[DISCOUNT_IDC_2], T1.[DISCOUNT_IDC_3], T1.[DISCOUNT_IDC_4], T1.[DISCOUNT_IDC_5], T1.[DISCOUNT_IDC_6], T1.[FACTORY_REPL_CD], T1.[AVERAGE_PRICE_YEAR], T1.[DEPOSIT], T1.[LUBRICANT], T1.[STANDARD_UNIT], T1.[UNIT_CONVERSION_SALES], T1.[UNIT_CONVERSION_PURCH], T1.[OIL], T1.[EXCHANGE_PART], T1.[MAKE_CD_CORE], T1.[PROD_CODE_CORE], T1.[SKIP_PRICE_CORR], T1.[BULKY_PART], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], T1.[CHASSISNO_ON_PURCH], T1.[GM_PART_NUMBER], T1.[QUANTITY_OF_SERVICES], T1.[PRICE_FACTOR], T1.[SPECIAL_ORDER_ITEM], T1.[FUEL_EFFICIENCY_CLASS], T1.[MANUALLY_CREATED], T1.[NOISE_CLASS], T1.[NOISE_RATE], T1.[PART_DESCRIPTION_CODE], T1.[PART_DESCRIPTION_EXTRACTED], T1.[PRODUCT_TYPE], T1.[TYRE_CLASS], T1.[WEET_GRIP_CLASS], T1.[PROD_NAME_200], T1.[MIN_ORDER_QTY], T1.[MODELS], T1.[PART_RETURNABLE_FLAG], T1.[PART_SIZE_CODE], T1.[PART_STATUS_CD], T1.[PMP_CD], T1.[TECHNICAL_BLOCK], T1.[ORIGINAL_PART], T1.[SARA_PART], '2' as [Client_DB] FROM [deop02].[dbo].[PRODUCT_FILE] T1  WHERE T1.[timestamp] > convert(binary(8), '%TS%', 1) AND 1 = 1 ORDER BY T1.[timestamp] "
  call bcp_in.bat "PRODUCT_FILE_2" "[temp].[PRODUCT_FILE]" "OPTIMAX"

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

:cleanup
  call delete.bat "C:\GlobalCube\System\OPTIMA\SQL\temp\PRODUCT_FILE_1.csv"
  call delete.bat "C:\GlobalCube\System\OPTIMA\SQL\temp\PRODUCT_FILE_2.csv"