SHARE
TWEET

Untitled

a guest Jun 25th, 2019 40 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DatabaseError: Execution failed on sql ....: ('22018', "[22018]
  2. [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when
  3. converting the nvarchar value 'P62' to data type int. (245)
  4. (SQLExecDirectW)")
  5.      
  6. query = """SELECT [Jaar], [Periode],[Status], [Goederengroep], [GGOmschrijving], [Regkol], [RKOmschrijving], [IOVM], [Lp] FROM [WERK].[vw_WERK_AGTData_Totalen]
  7. WHERE Jaar=2017 AND Regkol=64200"""
  8.  
  9. df = pd.read_sql(query, sql_con)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top