Re: [sqlalchemy] SQL's 'Warning: Null value is eliminated by an aggregate or other SET operation.' overflowing conn.execute(sql)?

2020-04-07 Thread Iván Gómez Villafañe
BC driver are doing with the SQL > commands being passed to them. > > > > On Tue, Apr 7, 2020, at 3:12 PM, Iván Gómez Villafañe wrote: > > PS. errata, change var1/var2 for col1/col2.. > > -- SQL START > > SET ANSI_WARNINGS OFF > > SELECT > id_col, &

Re: [sqlalchemy] SQL's 'Warning: Null value is eliminated by an aggregate or other SET operation.' overflowing conn.execute(sql)?

2020-04-07 Thread Iván Gómez Villafañe
avg_col2_neg) / @std_col2_neg AS col2_neg INTO output_table FROM output_table_temp; DROP TABLE output_table_temp; On Tuesday, 7 April 2020 16:09:10 UTC-3, Iván Gómez Villafañe wrote: > > Hi Mike, thanks for your reply. > > Regarding context, here's a sample sql with 2 c

Re: [sqlalchemy] SQL's 'Warning: Null value is eliminated by an aggregate or other SET operation.' overflowing conn.execute(sql)?

2020-04-07 Thread Iván Gómez Villafañe
tually executed" since there's not really > any example or context provided here. > > > > On Tue, Apr 7, 2020, at 2:25 PM, Iván Gómez Villafañe wrote: > > I have my own tran() function, as the doc suggests: > > engine = sqlalchemy.create_engine( > 'mssql+pyodbc:/

[sqlalchemy] SQL's 'Warning: Null value is eliminated by an aggregate or other SET operation.' overflowing conn.execute(sql)?

2020-04-07 Thread Iván Gómez Villafañe
I have my own tran() function, as the doc suggests: engine = sqlalchemy.create_engine( 'mssql+pyodbc://@SHINKEN/supervielle?trusted_connection=yes&driver=ODBC+Driver+13+for+SQL+Server' , fast_executemany = True) def tran(sql,engine): with engine.begin() as conn: conn.execute(sql) I ex