How to Create a Cache SQL Temp Table?
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 --