On Aug 2, 2:31 pm, Thomas Mueller <thomas.tom.muel...@gmail.com> wrote: > You have a serious complexity problem here.
No I don't ;) These are aggregating reports that do some pretty nifty aggregation & calculation on a daily basis. And in order to re-use the intermediate results CTEs are very useful. Views are not really an option as each of those CTEs is passed a parameter (the calculation runs in a stored procedure). Using the parameters directly in the CTE is a bit faster than applying the corresponding WHERE clause to a generalized view. But as Dario says: that's not the point. CTEs *are* useful, and it would be nice if H2 supported them as well. Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-datab...@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.