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

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

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

:full
  call sql_query.bat "TRUNCATE TABLE [OPTIMA].[import].[CUSTOMER]"
rem Nur in Quelle: SPEEDER_CUST_GROUP;PSA_RRDI_CODE;KREDIT_STOP_CASH;DUP_STATUS;KREDIT_STOP_CONSIG;KREDIT_STOP_DEMO;FORGOTTEN;PREFERREDPHONE;PREFERRED_CHANNEL_2;ELEC_INVOICE_FORM_VEH;ADVERTISING_PROTECTION;PUBLIC_ID_NUMBER;DUP_MAIN_CUSTOMER_NUMBER;ADDITIONAL_PDF_ELEC_INV;DIGITAL_SIGNATURE;INVOICE_EXPORT_TYPE
  call bcp_queryout.bat "CUSTOMER_1" "SELECT T1.[CUSTOMER_NUMBER], T1.[STATE_CODE_CUST], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[CUST_ALT_KEY], T1.[NAME], T1.[STREET_ADDR], T1.[ADDR_2], T1.[MAIL_ADDR], T1.[ZIPCODE], T1.[DEBIT_CUSTOMER], T1.[TITLE_CODE], T1.[TITLE], T1.[PMT_TERM], T1.[INVOICE_COPY_CODE], T1.[DELIVERY_WAY_CODE], T1.[SMALL_ACCESSORIES], T1.[SMALL_INV_CHARGE], T1.[WORKSHOP_PRICECODE], T1.[VAT_REGNO], T1.[SALESMAN], T1.[GROSS_DISCOUNT], T1.[DELIVERY_STOP_CODE], T1.[CREDIT_LIMIT], T1.[REMINDER_CODE], T1.[ACCOUNT_TYPE_CU], T1.[ACCOUNT_PRINT], T1.[BANK_NAME], T1.[BANK_REG_NO], T1.[BANK_ACCOUNT_NO], T1.[PAYMENT_WAY], T1.[PRICE_CODE], T1.[DISCOUNT_PERC_WORK], T1.[DISCOUNT_LIMIT], T1.[ANNUAL_DISC_PERC], T1.[ANNUAL_DISC_AMOUNT], T1.[ANNUAL_DISC_CODE], T1.[ADVERT_DISC_PERC], T1.[ADVERT_DISC_AMOUNT], T1.[INTERNAL_CODE_CUST], T1.[CUSTOMER_GROUP], T1.[CUSTOMER_PROSPECT], T1.[TAX_CODE], T1.[FLEET_OWNER], T1.[CONTACT_PERSON], T1.[PHONE_1], T1.[PHONE_2], T1.[COMMENT_1], T1.[COMMENT_2], 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.[LAST_INVOICE_DATE], T1.[PROFIT_C_U], T1.[DEBITED_MM_CUST], T1.[DEBITED_TY_CUST], T1.[DEBITED_PRYE_CUST], T1.[DISCOUNT_MM_CUST], T1.[DISCOUNT_TY_CUST], T1.[DISCOUNT_PY_CUST], T1.[MARG_MM_CUST], T1.[MARG_TY_CUST], T1.[MARG_PY_CUST], T1.[SALDO_C_U_CUST], T1.[LAST_PMT_DTE_CUST], T1.[PMT_TIME_CUST], T1.[INTERESTS], T1.[SALDO_LAST_ST], T1.[AOS_DEAL_NUMBER], T1.[CPR_NUMBER], T1.[DELETE_PROPOSAL], T1.[CREATION_DATE], T1.[CREATER], T1.[REDUCTION_CODE], T1.[START_NO], T1.[LAST_NO], T1.[LATEST_PERIOD], T1.[REMINDER_GROUP], T1.[REMINDER_DATE], T1.[PMT_TERMCODE_2], T1.[BACK_ORDER_DELIV], T1.[COUNTRY_CODE_CU], T1.[INSTALMENT_CODE], T1.[FOLLOW_UP_CU], T1.[VAT_TABLE_WORK], T1.[VAT_TABLE_NORMAL], T1.[VAT_TABLE], T1.[OCCUPATION_CODE], T1.[TELEFAX_NUMBER], T1.[LANGUAGE_CODE], T1.[BIRTHDAY], T1.[BIRTHDAY2], T1.[ADDR_3], T1.[COUNTY], T1.[MAX_BOOKING_DAYS], T1.[DEPARTMENT_5], T1.[RIB_KEY], T1.[PRICE_A_G], T1.[REQ_NO_COMPULSORY], T1.[VAT_REGNO_EU], T1.[WORKSHOP_SALESMAN], T1.[HOURLY_REPAIR_RATE], T1.[ELEC_INVOICE], T1.[ELEC_DEL_NOTE], T1.[ELEC_ORDER_CONF], T1.[ELEC_INVOICE_FORM], T1.[ELEC_COLL_INV_FORM], T1.[ELEC_DEL_NOTE_FORM], T1.[ELEC_ORD_CONF_FORM], T1.[ONLY_COLL_INVOICE], T1.[CUST_COMPANY_NO], T1.[DEALER_NUMBER], T1.[MOBILE_PHONE], T1.[MOBILE_PHONE_2], T1.[E_MAIL_ADDRESS], T1.[E_MAIL_ADDRESS_2], T1.[BRANCH], T1.[DECLARATION_STATE], T1.[USE_WORK_TYPE_CODE], T1.[FLEET_ID_NUMBER], T1.[FIRST_NAME], T1.[LAST_NAME], T1.[GENDER], T1.[COMPANY], T1.[MAIL_SUPPRESS], T1.[PO_BOX_15], T1.[PO_BOX_ZIPCODE], T1.[PO_BOX_TOWN], T1.[WEB_ADDRESS], T1.[FAMILY_STATUS], T1.[CHILDREN], T1.[HOBBY], T1.[EXT_CUSTOMER_GROUP], T1.[MEMBERSHIP_NUMBER], T1.[TRADE_REGISTER], T1.[PDF_INVOICE], T1.[E_COMMERCE_VEH], T1.[E_MAIL_ADDRESS_3], T1.[SEND_ORDER_ADVICE], T1.[SALES_LOCATION], T1.[SERVICE_LOCATION], T1.[STREET_NUMBER], T1.[STREET_NUMBER_EXT], T1.[STREET_NUMBER_EXT2], T1.[MAIL_ADDR_2], T1.[COUNTY_2], T1.[EXTERNAL_ID], T1.[LICENSE_NUMBER], T1.[STREET_NUMBER_2], T1.[V5_CUSTOMER_TYPE], T1.[ZIPCODE_2], T1.[DECL_STATE_DATE], T1.[ORDER_LIMIT], T1.[ADDR_2_2], T1.[ADDR_3_2], T1.[INTERNAL_TRANSFER], T1.[COLLECT_INV_FREQUENCY], T1.[VAT_SUSPENSION], T1.[CUSTOMER_GROUP_VEH], T1.[RENAULT_DEALER_NUMBER], T1.[RENAULT_TRANS_METHOD], T1.[BIRTH_PLACE], T1.[BIRTH_TOWN_CODE], T1.[COMPANY_ACRONYM_CODE], T1.[REGISTERED_OFFICE], T1.[INCOME_TAX_CODE], T1.[HOBBY_CODE], T1.[AGENT_CODE], T1.[BANK_BRANCH_REG_NO], T1.[INVOICE_FORM_CODE_NON_ELEC], T1.[FREIGHT_PER_DAY], T1.[PDF_STATEMENT], T1.[PDF_FORMCODE], T1.[E_MAIL_ADDRESS_4], T1.[IN_HOUSE_FINANCING], T1.[INSURANCE_CODE], T1.[HANDLER_SYSTEM], T1.[LOCATION_CODE], T1.[SKIP_CUST_DATA_CHECKS], T1.[OBSOLETE], T1.[FREIGHT_FEE_GROUP], T1.[CASH_MARK], T1.[SEND_ORDER_FOLLOW_UP], T1.[VEH_CERTIFICATE_PRINT_IMP], T1.[DECL_FIRST_CHANGE_DATE], T1.[DECL_LAST_CUST_CONT_DATE], T1.[DECL_LAST_CHANGE_ORDER_NO], T1.[DECL_STATE_ORIGIN], T1.[DECL_STATE_REMARK], T1.[PDF_INTEREST_INVOICE], T1.[PDF_FORMCODE_II], T1.[E_MAIL_ADDRESS_5], T1.[PDF_CLAIM_INVOICE], T1.[PDF_FORMCODE_CI], T1.[E_MAIL_ADDRESS_6], T1.[BIC], T1.[IBAN], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], T1.[PMT_CODE_VEHICLE], T1.[BYPASS_AUTO_SEARCH], T1.[E_MAIL_ADDRESS_7], T1.[IDENTITY_CARD], T1.[SMALL_ACCESS_SEPARATE], T1.[E_MAIL_ADDRESS_8], T1.[PDF_FORMCODE_RL], T1.[PDF_REMINDER_LETTER], T1.[DECL_FORM_PRESENTED], T1.[E_MAIL_ADDRESS_10], T1.[E_MAIL_ADDRESS_9], T1.[FORD_PAYMENT_CARD], T1.[PDF_FORMCODE_L1], T1.[PDF_FORMCODE_L2], T1.[PDF_LEASING_INVOICE], T1.[PDF_SERVICE_INVOICE], T1.[SHOW_TIME_PRICE], T1.[CENTRAL_CUSTOMER_FILE], T1.[CONTACT_FIRST_NAME], T1.[CONTACT_LAST_NAME], T1.[CONTACT_TITLE], T1.[CONTACT_TITLE_CODE], T1.[E_MAIL_ADDRESS_11], T1.[MOBILE_PHONE_3], T1.[PDF_FORMCODE_SC], T1.[PDF_SEPA_NOTIFICATION], T1.[PDF_SERVICE_CONTRACT], T1.[PREFERRED_CHANNEL], T1.[PREFERRED_SMART_PAY], T1.[RENAULT_BRANCH], '1' as [Client_DB] FROM [deop01].[dbo].[CUSTOMER] T1  WHERE 1 = 1 ORDER BY T1.[timestamp] "
  call bcp_in.bat "CUSTOMER_1" "[import].[CUSTOMER]" "OPTIMA"
rem Nur in Quelle: SPEEDER_CUST_GROUP;PSA_RRDI_CODE;KREDIT_STOP_CASH;DUP_STATUS;KREDIT_STOP_CONSIG;KREDIT_STOP_DEMO;FORGOTTEN;PREFERREDPHONE;PREFERRED_CHANNEL_2;ELEC_INVOICE_FORM_VEH;ADVERTISING_PROTECTION;PUBLIC_ID_NUMBER;DUP_MAIN_CUSTOMER_NUMBER;ADDITIONAL_PDF_ELEC_INV;DIGITAL_SIGNATURE;INVOICE_EXPORT_TYPE
  call bcp_queryout.bat "CUSTOMER_2" "SELECT T1.[CUSTOMER_NUMBER], T1.[STATE_CODE_CUST], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[CUST_ALT_KEY], T1.[NAME], T1.[STREET_ADDR], T1.[ADDR_2], T1.[MAIL_ADDR], T1.[ZIPCODE], T1.[DEBIT_CUSTOMER], T1.[TITLE_CODE], T1.[TITLE], T1.[PMT_TERM], T1.[INVOICE_COPY_CODE], T1.[DELIVERY_WAY_CODE], T1.[SMALL_ACCESSORIES], T1.[SMALL_INV_CHARGE], T1.[WORKSHOP_PRICECODE], T1.[VAT_REGNO], T1.[SALESMAN], T1.[GROSS_DISCOUNT], T1.[DELIVERY_STOP_CODE], T1.[CREDIT_LIMIT], T1.[REMINDER_CODE], T1.[ACCOUNT_TYPE_CU], T1.[ACCOUNT_PRINT], T1.[BANK_NAME], T1.[BANK_REG_NO], T1.[BANK_ACCOUNT_NO], T1.[PAYMENT_WAY], T1.[PRICE_CODE], T1.[DISCOUNT_PERC_WORK], T1.[DISCOUNT_LIMIT], T1.[ANNUAL_DISC_PERC], T1.[ANNUAL_DISC_AMOUNT], T1.[ANNUAL_DISC_CODE], T1.[ADVERT_DISC_PERC], T1.[ADVERT_DISC_AMOUNT], T1.[INTERNAL_CODE_CUST], T1.[CUSTOMER_GROUP], T1.[CUSTOMER_PROSPECT], T1.[TAX_CODE], T1.[FLEET_OWNER], T1.[CONTACT_PERSON], T1.[PHONE_1], T1.[PHONE_2], T1.[COMMENT_1], T1.[COMMENT_2], 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.[LAST_INVOICE_DATE], T1.[PROFIT_C_U], T1.[DEBITED_MM_CUST], T1.[DEBITED_TY_CUST], T1.[DEBITED_PRYE_CUST], T1.[DISCOUNT_MM_CUST], T1.[DISCOUNT_TY_CUST], T1.[DISCOUNT_PY_CUST], T1.[MARG_MM_CUST], T1.[MARG_TY_CUST], T1.[MARG_PY_CUST], T1.[SALDO_C_U_CUST], T1.[LAST_PMT_DTE_CUST], T1.[PMT_TIME_CUST], T1.[INTERESTS], T1.[SALDO_LAST_ST], T1.[AOS_DEAL_NUMBER], T1.[CPR_NUMBER], T1.[DELETE_PROPOSAL], T1.[CREATION_DATE], T1.[CREATER], T1.[REDUCTION_CODE], T1.[START_NO], T1.[LAST_NO], T1.[LATEST_PERIOD], T1.[REMINDER_GROUP], T1.[REMINDER_DATE], T1.[PMT_TERMCODE_2], T1.[BACK_ORDER_DELIV], T1.[COUNTRY_CODE_CU], T1.[INSTALMENT_CODE], T1.[FOLLOW_UP_CU], T1.[VAT_TABLE_WORK], T1.[VAT_TABLE_NORMAL], T1.[VAT_TABLE], T1.[OCCUPATION_CODE], T1.[TELEFAX_NUMBER], T1.[LANGUAGE_CODE], T1.[BIRTHDAY], T1.[BIRTHDAY2], T1.[ADDR_3], T1.[COUNTY], T1.[MAX_BOOKING_DAYS], T1.[DEPARTMENT_5], T1.[RIB_KEY], T1.[PRICE_A_G], T1.[REQ_NO_COMPULSORY], T1.[VAT_REGNO_EU], T1.[WORKSHOP_SALESMAN], T1.[HOURLY_REPAIR_RATE], T1.[ELEC_INVOICE], T1.[ELEC_DEL_NOTE], T1.[ELEC_ORDER_CONF], T1.[ELEC_INVOICE_FORM], T1.[ELEC_COLL_INV_FORM], T1.[ELEC_DEL_NOTE_FORM], T1.[ELEC_ORD_CONF_FORM], T1.[ONLY_COLL_INVOICE], T1.[CUST_COMPANY_NO], T1.[DEALER_NUMBER], T1.[MOBILE_PHONE], T1.[MOBILE_PHONE_2], T1.[E_MAIL_ADDRESS], T1.[E_MAIL_ADDRESS_2], T1.[BRANCH], T1.[DECLARATION_STATE], T1.[USE_WORK_TYPE_CODE], T1.[FLEET_ID_NUMBER], T1.[FIRST_NAME], T1.[LAST_NAME], T1.[GENDER], T1.[COMPANY], T1.[MAIL_SUPPRESS], T1.[PO_BOX_15], T1.[PO_BOX_ZIPCODE], T1.[PO_BOX_TOWN], T1.[WEB_ADDRESS], T1.[FAMILY_STATUS], T1.[CHILDREN], T1.[HOBBY], T1.[EXT_CUSTOMER_GROUP], T1.[MEMBERSHIP_NUMBER], T1.[TRADE_REGISTER], T1.[PDF_INVOICE], T1.[E_COMMERCE_VEH], T1.[E_MAIL_ADDRESS_3], T1.[SEND_ORDER_ADVICE], T1.[SALES_LOCATION], T1.[SERVICE_LOCATION], T1.[STREET_NUMBER], T1.[STREET_NUMBER_EXT], T1.[STREET_NUMBER_EXT2], T1.[MAIL_ADDR_2], T1.[COUNTY_2], T1.[EXTERNAL_ID], T1.[LICENSE_NUMBER], T1.[STREET_NUMBER_2], T1.[V5_CUSTOMER_TYPE], T1.[ZIPCODE_2], T1.[DECL_STATE_DATE], T1.[ORDER_LIMIT], T1.[ADDR_2_2], T1.[ADDR_3_2], T1.[INTERNAL_TRANSFER], T1.[COLLECT_INV_FREQUENCY], T1.[VAT_SUSPENSION], T1.[CUSTOMER_GROUP_VEH], T1.[RENAULT_DEALER_NUMBER], T1.[RENAULT_TRANS_METHOD], T1.[BIRTH_PLACE], T1.[BIRTH_TOWN_CODE], T1.[COMPANY_ACRONYM_CODE], T1.[REGISTERED_OFFICE], T1.[INCOME_TAX_CODE], T1.[HOBBY_CODE], T1.[AGENT_CODE], T1.[BANK_BRANCH_REG_NO], T1.[INVOICE_FORM_CODE_NON_ELEC], T1.[FREIGHT_PER_DAY], T1.[PDF_STATEMENT], T1.[PDF_FORMCODE], T1.[E_MAIL_ADDRESS_4], T1.[IN_HOUSE_FINANCING], T1.[INSURANCE_CODE], T1.[HANDLER_SYSTEM], T1.[LOCATION_CODE], T1.[SKIP_CUST_DATA_CHECKS], T1.[OBSOLETE], T1.[FREIGHT_FEE_GROUP], T1.[CASH_MARK], T1.[SEND_ORDER_FOLLOW_UP], T1.[VEH_CERTIFICATE_PRINT_IMP], T1.[DECL_FIRST_CHANGE_DATE], T1.[DECL_LAST_CUST_CONT_DATE], T1.[DECL_LAST_CHANGE_ORDER_NO], T1.[DECL_STATE_ORIGIN], T1.[DECL_STATE_REMARK], T1.[PDF_INTEREST_INVOICE], T1.[PDF_FORMCODE_II], T1.[E_MAIL_ADDRESS_5], T1.[PDF_CLAIM_INVOICE], T1.[PDF_FORMCODE_CI], T1.[E_MAIL_ADDRESS_6], T1.[BIC], T1.[IBAN], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], T1.[PMT_CODE_VEHICLE], T1.[BYPASS_AUTO_SEARCH], T1.[E_MAIL_ADDRESS_7], T1.[IDENTITY_CARD], T1.[SMALL_ACCESS_SEPARATE], T1.[E_MAIL_ADDRESS_8], T1.[PDF_FORMCODE_RL], T1.[PDF_REMINDER_LETTER], T1.[DECL_FORM_PRESENTED], T1.[E_MAIL_ADDRESS_10], T1.[E_MAIL_ADDRESS_9], T1.[FORD_PAYMENT_CARD], T1.[PDF_FORMCODE_L1], T1.[PDF_FORMCODE_L2], T1.[PDF_LEASING_INVOICE], T1.[PDF_SERVICE_INVOICE], T1.[SHOW_TIME_PRICE], T1.[CENTRAL_CUSTOMER_FILE], T1.[CONTACT_FIRST_NAME], T1.[CONTACT_LAST_NAME], T1.[CONTACT_TITLE], T1.[CONTACT_TITLE_CODE], T1.[E_MAIL_ADDRESS_11], T1.[MOBILE_PHONE_3], T1.[PDF_FORMCODE_SC], T1.[PDF_SEPA_NOTIFICATION], T1.[PDF_SERVICE_CONTRACT], T1.[PREFERRED_CHANNEL], T1.[PREFERRED_SMART_PAY], T1.[RENAULT_BRANCH], '2' as [Client_DB] FROM [deop02].[dbo].[CUSTOMER] T1  WHERE 1 = 1 ORDER BY T1.[timestamp] "
  call bcp_in.bat "CUSTOMER_2" "[import].[CUSTOMER]" "OPTIMA"
  goto :cleanup

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

  call sql_timestamp.bat "CUSTOMER_1" "[OPTIMA].[import].[CUSTOMER]" "1"
  call bcp_queryout.bat "CUSTOMER_1" "SELECT T1.[CUSTOMER_NUMBER], T1.[STATE_CODE_CUST], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[CUST_ALT_KEY], T1.[NAME], T1.[STREET_ADDR], T1.[ADDR_2], T1.[MAIL_ADDR], T1.[ZIPCODE], T1.[DEBIT_CUSTOMER], T1.[TITLE_CODE], T1.[TITLE], T1.[PMT_TERM], T1.[INVOICE_COPY_CODE], T1.[DELIVERY_WAY_CODE], T1.[SMALL_ACCESSORIES], T1.[SMALL_INV_CHARGE], T1.[WORKSHOP_PRICECODE], T1.[VAT_REGNO], T1.[SALESMAN], T1.[GROSS_DISCOUNT], T1.[DELIVERY_STOP_CODE], T1.[CREDIT_LIMIT], T1.[REMINDER_CODE], T1.[ACCOUNT_TYPE_CU], T1.[ACCOUNT_PRINT], T1.[BANK_NAME], T1.[BANK_REG_NO], T1.[BANK_ACCOUNT_NO], T1.[PAYMENT_WAY], T1.[PRICE_CODE], T1.[DISCOUNT_PERC_WORK], T1.[DISCOUNT_LIMIT], T1.[ANNUAL_DISC_PERC], T1.[ANNUAL_DISC_AMOUNT], T1.[ANNUAL_DISC_CODE], T1.[ADVERT_DISC_PERC], T1.[ADVERT_DISC_AMOUNT], T1.[INTERNAL_CODE_CUST], T1.[CUSTOMER_GROUP], T1.[CUSTOMER_PROSPECT], T1.[TAX_CODE], T1.[FLEET_OWNER], T1.[CONTACT_PERSON], T1.[PHONE_1], T1.[PHONE_2], T1.[COMMENT_1], T1.[COMMENT_2], 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.[LAST_INVOICE_DATE], T1.[PROFIT_C_U], T1.[DEBITED_MM_CUST], T1.[DEBITED_TY_CUST], T1.[DEBITED_PRYE_CUST], T1.[DISCOUNT_MM_CUST], T1.[DISCOUNT_TY_CUST], T1.[DISCOUNT_PY_CUST], T1.[MARG_MM_CUST], T1.[MARG_TY_CUST], T1.[MARG_PY_CUST], T1.[SALDO_C_U_CUST], T1.[LAST_PMT_DTE_CUST], T1.[PMT_TIME_CUST], T1.[INTERESTS], T1.[SALDO_LAST_ST], T1.[AOS_DEAL_NUMBER], T1.[CPR_NUMBER], T1.[DELETE_PROPOSAL], T1.[CREATION_DATE], T1.[CREATER], T1.[REDUCTION_CODE], T1.[START_NO], T1.[LAST_NO], T1.[LATEST_PERIOD], T1.[REMINDER_GROUP], T1.[REMINDER_DATE], T1.[PMT_TERMCODE_2], T1.[BACK_ORDER_DELIV], T1.[COUNTRY_CODE_CU], T1.[INSTALMENT_CODE], T1.[FOLLOW_UP_CU], T1.[VAT_TABLE_WORK], T1.[VAT_TABLE_NORMAL], T1.[VAT_TABLE], T1.[OCCUPATION_CODE], T1.[TELEFAX_NUMBER], T1.[LANGUAGE_CODE], T1.[BIRTHDAY], T1.[BIRTHDAY2], T1.[ADDR_3], T1.[COUNTY], T1.[MAX_BOOKING_DAYS], T1.[DEPARTMENT_5], T1.[RIB_KEY], T1.[PRICE_A_G], T1.[REQ_NO_COMPULSORY], T1.[VAT_REGNO_EU], T1.[WORKSHOP_SALESMAN], T1.[HOURLY_REPAIR_RATE], T1.[ELEC_INVOICE], T1.[ELEC_DEL_NOTE], T1.[ELEC_ORDER_CONF], T1.[ELEC_INVOICE_FORM], T1.[ELEC_COLL_INV_FORM], T1.[ELEC_DEL_NOTE_FORM], T1.[ELEC_ORD_CONF_FORM], T1.[ONLY_COLL_INVOICE], T1.[CUST_COMPANY_NO], T1.[DEALER_NUMBER], T1.[MOBILE_PHONE], T1.[MOBILE_PHONE_2], T1.[E_MAIL_ADDRESS], T1.[E_MAIL_ADDRESS_2], T1.[BRANCH], T1.[DECLARATION_STATE], T1.[USE_WORK_TYPE_CODE], T1.[FLEET_ID_NUMBER], T1.[FIRST_NAME], T1.[LAST_NAME], T1.[GENDER], T1.[COMPANY], T1.[MAIL_SUPPRESS], T1.[PO_BOX_15], T1.[PO_BOX_ZIPCODE], T1.[PO_BOX_TOWN], T1.[WEB_ADDRESS], T1.[FAMILY_STATUS], T1.[CHILDREN], T1.[HOBBY], T1.[EXT_CUSTOMER_GROUP], T1.[MEMBERSHIP_NUMBER], T1.[TRADE_REGISTER], T1.[PDF_INVOICE], T1.[E_COMMERCE_VEH], T1.[E_MAIL_ADDRESS_3], T1.[SEND_ORDER_ADVICE], T1.[SALES_LOCATION], T1.[SERVICE_LOCATION], T1.[STREET_NUMBER], T1.[STREET_NUMBER_EXT], T1.[STREET_NUMBER_EXT2], T1.[MAIL_ADDR_2], T1.[COUNTY_2], T1.[EXTERNAL_ID], T1.[LICENSE_NUMBER], T1.[STREET_NUMBER_2], T1.[V5_CUSTOMER_TYPE], T1.[ZIPCODE_2], T1.[DECL_STATE_DATE], T1.[ORDER_LIMIT], T1.[ADDR_2_2], T1.[ADDR_3_2], T1.[INTERNAL_TRANSFER], T1.[COLLECT_INV_FREQUENCY], T1.[VAT_SUSPENSION], T1.[CUSTOMER_GROUP_VEH], T1.[RENAULT_DEALER_NUMBER], T1.[RENAULT_TRANS_METHOD], T1.[BIRTH_PLACE], T1.[BIRTH_TOWN_CODE], T1.[COMPANY_ACRONYM_CODE], T1.[REGISTERED_OFFICE], T1.[INCOME_TAX_CODE], T1.[HOBBY_CODE], T1.[AGENT_CODE], T1.[BANK_BRANCH_REG_NO], T1.[INVOICE_FORM_CODE_NON_ELEC], T1.[FREIGHT_PER_DAY], T1.[PDF_STATEMENT], T1.[PDF_FORMCODE], T1.[E_MAIL_ADDRESS_4], T1.[IN_HOUSE_FINANCING], T1.[INSURANCE_CODE], T1.[HANDLER_SYSTEM], T1.[LOCATION_CODE], T1.[SKIP_CUST_DATA_CHECKS], T1.[OBSOLETE], T1.[FREIGHT_FEE_GROUP], T1.[CASH_MARK], T1.[SEND_ORDER_FOLLOW_UP], T1.[VEH_CERTIFICATE_PRINT_IMP], T1.[DECL_FIRST_CHANGE_DATE], T1.[DECL_LAST_CUST_CONT_DATE], T1.[DECL_LAST_CHANGE_ORDER_NO], T1.[DECL_STATE_ORIGIN], T1.[DECL_STATE_REMARK], T1.[PDF_INTEREST_INVOICE], T1.[PDF_FORMCODE_II], T1.[E_MAIL_ADDRESS_5], T1.[PDF_CLAIM_INVOICE], T1.[PDF_FORMCODE_CI], T1.[E_MAIL_ADDRESS_6], T1.[BIC], T1.[IBAN], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], T1.[PMT_CODE_VEHICLE], T1.[BYPASS_AUTO_SEARCH], T1.[E_MAIL_ADDRESS_7], T1.[IDENTITY_CARD], T1.[SMALL_ACCESS_SEPARATE], T1.[E_MAIL_ADDRESS_8], T1.[PDF_FORMCODE_RL], T1.[PDF_REMINDER_LETTER], T1.[DECL_FORM_PRESENTED], T1.[E_MAIL_ADDRESS_10], T1.[E_MAIL_ADDRESS_9], T1.[FORD_PAYMENT_CARD], T1.[PDF_FORMCODE_L1], T1.[PDF_FORMCODE_L2], T1.[PDF_LEASING_INVOICE], T1.[PDF_SERVICE_INVOICE], T1.[SHOW_TIME_PRICE], T1.[CENTRAL_CUSTOMER_FILE], T1.[CONTACT_FIRST_NAME], T1.[CONTACT_LAST_NAME], T1.[CONTACT_TITLE], T1.[CONTACT_TITLE_CODE], T1.[E_MAIL_ADDRESS_11], T1.[MOBILE_PHONE_3], T1.[PDF_FORMCODE_SC], T1.[PDF_SEPA_NOTIFICATION], T1.[PDF_SERVICE_CONTRACT], T1.[PREFERRED_CHANNEL], T1.[PREFERRED_SMART_PAY], T1.[RENAULT_BRANCH], '1' as [Client_DB] FROM [deop01].[dbo].[CUSTOMER] T1  WHERE T1.[timestamp] > convert(binary(8), '%TS%', 1) AND 1 = 1 ORDER BY T1.[timestamp] "
  call bcp_in.bat "CUSTOMER_1" "[temp].[CUSTOMER]" "OPTIMAX"

  call sql_timestamp.bat "CUSTOMER_2" "[OPTIMA].[import].[CUSTOMER]" "2"
  call bcp_queryout.bat "CUSTOMER_2" "SELECT T1.[CUSTOMER_NUMBER], T1.[STATE_CODE_CUST], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[CUST_ALT_KEY], T1.[NAME], T1.[STREET_ADDR], T1.[ADDR_2], T1.[MAIL_ADDR], T1.[ZIPCODE], T1.[DEBIT_CUSTOMER], T1.[TITLE_CODE], T1.[TITLE], T1.[PMT_TERM], T1.[INVOICE_COPY_CODE], T1.[DELIVERY_WAY_CODE], T1.[SMALL_ACCESSORIES], T1.[SMALL_INV_CHARGE], T1.[WORKSHOP_PRICECODE], T1.[VAT_REGNO], T1.[SALESMAN], T1.[GROSS_DISCOUNT], T1.[DELIVERY_STOP_CODE], T1.[CREDIT_LIMIT], T1.[REMINDER_CODE], T1.[ACCOUNT_TYPE_CU], T1.[ACCOUNT_PRINT], T1.[BANK_NAME], T1.[BANK_REG_NO], T1.[BANK_ACCOUNT_NO], T1.[PAYMENT_WAY], T1.[PRICE_CODE], T1.[DISCOUNT_PERC_WORK], T1.[DISCOUNT_LIMIT], T1.[ANNUAL_DISC_PERC], T1.[ANNUAL_DISC_AMOUNT], T1.[ANNUAL_DISC_CODE], T1.[ADVERT_DISC_PERC], T1.[ADVERT_DISC_AMOUNT], T1.[INTERNAL_CODE_CUST], T1.[CUSTOMER_GROUP], T1.[CUSTOMER_PROSPECT], T1.[TAX_CODE], T1.[FLEET_OWNER], T1.[CONTACT_PERSON], T1.[PHONE_1], T1.[PHONE_2], T1.[COMMENT_1], T1.[COMMENT_2], 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.[LAST_INVOICE_DATE], T1.[PROFIT_C_U], T1.[DEBITED_MM_CUST], T1.[DEBITED_TY_CUST], T1.[DEBITED_PRYE_CUST], T1.[DISCOUNT_MM_CUST], T1.[DISCOUNT_TY_CUST], T1.[DISCOUNT_PY_CUST], T1.[MARG_MM_CUST], T1.[MARG_TY_CUST], T1.[MARG_PY_CUST], T1.[SALDO_C_U_CUST], T1.[LAST_PMT_DTE_CUST], T1.[PMT_TIME_CUST], T1.[INTERESTS], T1.[SALDO_LAST_ST], T1.[AOS_DEAL_NUMBER], T1.[CPR_NUMBER], T1.[DELETE_PROPOSAL], T1.[CREATION_DATE], T1.[CREATER], T1.[REDUCTION_CODE], T1.[START_NO], T1.[LAST_NO], T1.[LATEST_PERIOD], T1.[REMINDER_GROUP], T1.[REMINDER_DATE], T1.[PMT_TERMCODE_2], T1.[BACK_ORDER_DELIV], T1.[COUNTRY_CODE_CU], T1.[INSTALMENT_CODE], T1.[FOLLOW_UP_CU], T1.[VAT_TABLE_WORK], T1.[VAT_TABLE_NORMAL], T1.[VAT_TABLE], T1.[OCCUPATION_CODE], T1.[TELEFAX_NUMBER], T1.[LANGUAGE_CODE], T1.[BIRTHDAY], T1.[BIRTHDAY2], T1.[ADDR_3], T1.[COUNTY], T1.[MAX_BOOKING_DAYS], T1.[DEPARTMENT_5], T1.[RIB_KEY], T1.[PRICE_A_G], T1.[REQ_NO_COMPULSORY], T1.[VAT_REGNO_EU], T1.[WORKSHOP_SALESMAN], T1.[HOURLY_REPAIR_RATE], T1.[ELEC_INVOICE], T1.[ELEC_DEL_NOTE], T1.[ELEC_ORDER_CONF], T1.[ELEC_INVOICE_FORM], T1.[ELEC_COLL_INV_FORM], T1.[ELEC_DEL_NOTE_FORM], T1.[ELEC_ORD_CONF_FORM], T1.[ONLY_COLL_INVOICE], T1.[CUST_COMPANY_NO], T1.[DEALER_NUMBER], T1.[MOBILE_PHONE], T1.[MOBILE_PHONE_2], T1.[E_MAIL_ADDRESS], T1.[E_MAIL_ADDRESS_2], T1.[BRANCH], T1.[DECLARATION_STATE], T1.[USE_WORK_TYPE_CODE], T1.[FLEET_ID_NUMBER], T1.[FIRST_NAME], T1.[LAST_NAME], T1.[GENDER], T1.[COMPANY], T1.[MAIL_SUPPRESS], T1.[PO_BOX_15], T1.[PO_BOX_ZIPCODE], T1.[PO_BOX_TOWN], T1.[WEB_ADDRESS], T1.[FAMILY_STATUS], T1.[CHILDREN], T1.[HOBBY], T1.[EXT_CUSTOMER_GROUP], T1.[MEMBERSHIP_NUMBER], T1.[TRADE_REGISTER], T1.[PDF_INVOICE], T1.[E_COMMERCE_VEH], T1.[E_MAIL_ADDRESS_3], T1.[SEND_ORDER_ADVICE], T1.[SALES_LOCATION], T1.[SERVICE_LOCATION], T1.[STREET_NUMBER], T1.[STREET_NUMBER_EXT], T1.[STREET_NUMBER_EXT2], T1.[MAIL_ADDR_2], T1.[COUNTY_2], T1.[EXTERNAL_ID], T1.[LICENSE_NUMBER], T1.[STREET_NUMBER_2], T1.[V5_CUSTOMER_TYPE], T1.[ZIPCODE_2], T1.[DECL_STATE_DATE], T1.[ORDER_LIMIT], T1.[ADDR_2_2], T1.[ADDR_3_2], T1.[INTERNAL_TRANSFER], T1.[COLLECT_INV_FREQUENCY], T1.[VAT_SUSPENSION], T1.[CUSTOMER_GROUP_VEH], T1.[RENAULT_DEALER_NUMBER], T1.[RENAULT_TRANS_METHOD], T1.[BIRTH_PLACE], T1.[BIRTH_TOWN_CODE], T1.[COMPANY_ACRONYM_CODE], T1.[REGISTERED_OFFICE], T1.[INCOME_TAX_CODE], T1.[HOBBY_CODE], T1.[AGENT_CODE], T1.[BANK_BRANCH_REG_NO], T1.[INVOICE_FORM_CODE_NON_ELEC], T1.[FREIGHT_PER_DAY], T1.[PDF_STATEMENT], T1.[PDF_FORMCODE], T1.[E_MAIL_ADDRESS_4], T1.[IN_HOUSE_FINANCING], T1.[INSURANCE_CODE], T1.[HANDLER_SYSTEM], T1.[LOCATION_CODE], T1.[SKIP_CUST_DATA_CHECKS], T1.[OBSOLETE], T1.[FREIGHT_FEE_GROUP], T1.[CASH_MARK], T1.[SEND_ORDER_FOLLOW_UP], T1.[VEH_CERTIFICATE_PRINT_IMP], T1.[DECL_FIRST_CHANGE_DATE], T1.[DECL_LAST_CUST_CONT_DATE], T1.[DECL_LAST_CHANGE_ORDER_NO], T1.[DECL_STATE_ORIGIN], T1.[DECL_STATE_REMARK], T1.[PDF_INTEREST_INVOICE], T1.[PDF_FORMCODE_II], T1.[E_MAIL_ADDRESS_5], T1.[PDF_CLAIM_INVOICE], T1.[PDF_FORMCODE_CI], T1.[E_MAIL_ADDRESS_6], T1.[BIC], T1.[IBAN], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], T1.[PMT_CODE_VEHICLE], T1.[BYPASS_AUTO_SEARCH], T1.[E_MAIL_ADDRESS_7], T1.[IDENTITY_CARD], T1.[SMALL_ACCESS_SEPARATE], T1.[E_MAIL_ADDRESS_8], T1.[PDF_FORMCODE_RL], T1.[PDF_REMINDER_LETTER], T1.[DECL_FORM_PRESENTED], T1.[E_MAIL_ADDRESS_10], T1.[E_MAIL_ADDRESS_9], T1.[FORD_PAYMENT_CARD], T1.[PDF_FORMCODE_L1], T1.[PDF_FORMCODE_L2], T1.[PDF_LEASING_INVOICE], T1.[PDF_SERVICE_INVOICE], T1.[SHOW_TIME_PRICE], T1.[CENTRAL_CUSTOMER_FILE], T1.[CONTACT_FIRST_NAME], T1.[CONTACT_LAST_NAME], T1.[CONTACT_TITLE], T1.[CONTACT_TITLE_CODE], T1.[E_MAIL_ADDRESS_11], T1.[MOBILE_PHONE_3], T1.[PDF_FORMCODE_SC], T1.[PDF_SEPA_NOTIFICATION], T1.[PDF_SERVICE_CONTRACT], T1.[PREFERRED_CHANNEL], T1.[PREFERRED_SMART_PAY], T1.[RENAULT_BRANCH], '2' as [Client_DB] FROM [deop02].[dbo].[CUSTOMER] T1  WHERE T1.[timestamp] > convert(binary(8), '%TS%', 1) AND 1 = 1 ORDER BY T1.[timestamp] "
  call bcp_in.bat "CUSTOMER_2" "[temp].[CUSTOMER]" "OPTIMAX"

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

:cleanup
  call delete.bat "C:\GlobalCube\System\OPTIMA\SQL\temp\CUSTOMER_1.csv"
  call delete.bat "C:\GlobalCube\System\OPTIMA\SQL\temp\CUSTOMER_2.csv"