Hi Symeon, I have been trying to think how you would use CTE (or equivalents) in u2 SQL. Are you willing to enlighten us?
Regards Phil > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Symeon Breen > Sent: Thursday, 8 April 2010 8:16 p.m. > To: 'U2 Users List' > Subject: Re: [U2] Common Table Expressions > > 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 > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users