Synchroniser

 
    
      
        
             select
               left(COL_DokumentenNummer,8)     as dokument,
               left(COL_SuchText,30)            as bez,
               left(COL_DokumentenNummer
                || ' '
                || COL_SuchText,20)             as baustelle,
               left(COL_PostLeitZahl,6)         as plz,
               left(COL_Ort,30)                 as ort,
               left(COL_Strasse,60)             as strasse,
               left(COL_HausNummer,30)          as hausnummer,
               convert(varchar(2),COL_Erledigt) as erledigt
             from
               tbl_dokument
             where
               Col_DokumentenTyp = 'Arbeitsauftrag'
               and COL_Erledigt  = '0'
               and COL_IstInNK   = '1'
        
      
      
        
        
      
    

 cd /d %~dp0
..\bs2sync.exe baustellen.xml > baustellen.log