How to Create a Cache SQL Temp Table?

Question

Augie Turano · Oct 9, 2020

In MS SQL Server i can do this:

SELECT
Category, CrewNumber, MedicalCertificationDate, Seat, SeatbeltUsed, Sex, ShoulderHarnessUsed, ToxicologyTestPerformed, childsub
INTO #tempfemale
FROM Aviation.Crew
WHERE Sex = 'F'

The code would create a new temporary table with the fields defined from Aviation.Crew. I cannot find how to do this in Cache SQL in the documentation. Can someone show me the correct syntax or other solution? This is a very simple example but i have very large tables with a lot of fields that require numerous filters and where clauses, having this type of mechanism would be extremely useful.

Thanks --

#SQL #Caché