It could certainly work in u2 SQL - not sure how you would do this in English (MVQuery or whatever) tho
-----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: 08 April 2010 06:55 To: U2 Users List Subject: [U2] Common Table Expressions Just working on a SQL project which uses lots of CTEs (Common Table Expressions) for in-memory caching of table data. Really useful things in terms of speed and not having to create temporary tables for manipulating data. Wondering if anyone has thought about if or how they might work in U2... Just a thought for better and better (which is down at the moment.) Cheers, Stuart Boydell _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users