>>>> Hi,
>>>>
>>>> is there a best practice to share data between two select statements?
Hi,
I didn't check the whole thread so forgive me if this was already proposed,
but maybe you could do something like:
create temp table result2 (...)
query_1:
WITH cte as (select ..),
tmp as ( INSERT INTO result2 select ... from cte),
SELECT ... from cte;
query_2:
select * from result2;
It was, more or less. I'm not sure you buy much using an updating CTE in lieu of a dedicated statement populating the temporary table. It seems a bit more confusing to comprehend and the performance benefit has to be marginal given we expect to only insert a single row into the temp table.
David J.
