Using self.con.create_table(temp=True,...) on the MSSQL Backend, creates a persistent ibis_polars_memtable: I logged the raw_ddl statement that gets executed by ibis and it uses this syntax which ...

CREATE TABLE TEMP_NESTED_WITH AS WITH C AS ( WITH A AS (SELECT 2 AS value) SELECT * FROM A ) SELECT * FROM C; This query works in snowflake But when i transpile to to tsql, it doesn't work due to ...

(SQL Server 2000)<BR><BR>I have a query that basically selects a lot of "complicated" stuff and then dumps it into a #temp table.<BR><BR>I then have a correlated subquery that runs against the temp ...

Ok, I KNOW this is a very standard thing, but well... I'm having trouble finding it in Google so I'm looking through a TSQL programming book.<BR><BR>Anyway, I figured I'd post it here and see who gets ...