a guest Jun 25th, 2019 39 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- DatabaseError: Execution failed on sql ....: ('22018', "
- [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when
- converting the nvarchar value 'P62' to data type int. (245)
- query = """SELECT [Jaar], [Periode],[Status], [Goederengroep], [GGOmschrijving], [Regkol], [RKOmschrijving], [IOVM], [Lp] FROM [WERK].[vw_WERK_AGTData_Totalen]
- WHERE Jaar=2017 AND Regkol=64200"""
- df = pd.read_sql(query, sql_con)
RAW Paste Data