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

@echo off 
rem ==UNIT_CLASSIFICAT==
del C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA2\UNIT_CLASSIFICAT*.* /Q /F >nul 2>nul 
sqlcmd.exe -S localhost\GLOBALCUBE -d OPTIMA2 -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [import].[UNIT_CLASSIFICAT]" 
bcp "SELECT T1.[UNIT_NUMBER], T1.[BATCH_NUMBER_S], T1.[ACCTNG_PERIOD], T1.[LINE_NO], T1.[ACCT_NR], T1.[DEPARTMENT], T1.[BOOK_KEEPING_CODE], T1.[TRANSFER_CODE], T1.[TRANSACTION_DATE], T1.[TRANSACTION_CODE], T1.[TRANSACTION_AMOUNT], T1.[DOCUMENT_NR], T1.[TRANSFER_DIFFTAX], T1.[TRF_TAXBASIS_SALES], T1.[TRF_TAXBASIS_PURCH], T1.[BOOK_NO], T1.[PURCH_INVNO], T1.[ORIGINAL_BATCH_NO], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], '1' as \"Client_DB\" FROM [dbo].[UNIT_CLASSIFICAT] T1 INNER JOIN [dbo].[UNIT_FILE] T2 ON T1.[UNIT_NUMBER] = T2.[UNIT_NUMBER] INNER JOIN [dbo].[VEHICLE] T3 ON T2.[BASIS_NUMBER] = T3.[BASIS_NUMBER]  WHERE T3.[LAST_INVOICE_DTE] >= '01.01.2018'" queryout "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA2\UNIT_CLASSIFICAT_1.csv" -S DADE053821 -d deop01 -U sa -P sybjdc -c -C 65001 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA2\UNIT_CLASSIFICAT_1.queryout.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA2\UNIT_CLASSIFICAT_1.bcp1.log" 
type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA2\UNIT_CLASSIFICAT_1.bcp1.log" | findstr -v "1000" 
bcp [import].[UNIT_CLASSIFICAT] in "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA2\UNIT_CLASSIFICAT_1.csv" -S localhost\GLOBALCUBE -d OPTIMA2 -U sa -P Mffu3011# -c -C 65001 -m 1000 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA2\UNIT_CLASSIFICAT_1.in.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA2\UNIT_CLASSIFICAT_1.bcp2.log" 
type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA2\UNIT_CLASSIFICAT_1.bcp2.log" | findstr -v "1000"