Thanks Joe! What is "CTE"?Just in case you didn't catch Eric's excellent post, a common table expression is the "with t1 as..." syntax that basically allows you to define one or more temporary derived tables and then use those in a further expression. It's hugely powerful.
This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact