Re: [SQL] CTEs and re-use

> On Apr 11, 2017, at 8:43 PM, David G. Johnston  wrote:
> 
> On Tuesday, April 11, 2017, Rob Sargent  wrote:
> If ‘on commit drop’ does the trick that clears the annoyance but still wondering if there’s a way to retain the product of the CTE/select for further processing without resorting to a temp table.
> 
> A CTE is a same-query-only temp table.  If you need it to persist post query you have to use a real temporary table.
> 
> David J. 

Right then.  Thought I might be missing some nifty construct.  A little surprised but oh, well.

Thanks for taking the time.
rjs