Re: sqlalchemy & #temp tables

2019-10-11 Thread Albert-Jan Roskam
On 8 Oct 2019 07:49, Frank Millman wrote: On 2019-10-07 5:30 PM, Albert-Jan Roskam wrote: > Hi, > > I am using sqlalchemy (SA) to access a MS SQL Server database (python 3.5, > Win 10). I would like to use a temporary table (preferably #local, but > ##global would also be an option) to store

Re: sqlalchemy & #temp tables

2019-10-07 Thread Frank Millman
On 2019-10-07 5:30 PM, Albert-Jan Roskam wrote: Hi, I am using sqlalchemy (SA) to access a MS SQL Server database (python 3.5, Win 10). I would like to use a temporary table (preferably #local, but ##global would also be an option) to store results of a time-consuming query. In other queries

sqlalchemy & #temp tables

2019-10-07 Thread Albert-Jan Roskam
Hi, I am using sqlalchemy (SA) to access a MS SQL Server database (python 3.5, Win 10). I would like to use a temporary table (preferably #local, but ##global would also be an option) to store results of a time-consuming query. In other queries I'd like to access the temporary table again in va