I'd have to think about it a bit, but wouldn't your scenario be a good case for a BY-EXP clause? I haven't used a BY-EXP in years! :o
-----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Thursday, April 08, 2010 5:27 PM To: U2 Users List Subject: Re: [U2] Common Table Expressions One scenario off the top of my head would be to allow recursive selects. This would be similar to a qselect, where you select a list of MVs from a record, but would also allow you to include the parent id and any child ids and grandchild ids, etc as a result of the CTE select. Eg. A master customer AC has child accounts which may also have child ACs - you would use a CTE to select the customer and return the parent and list of children and grandchildren etc in a single optimised select. To do this in U2 now probably requires a recursive basic program. Stuart Boydell -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Friday, 9 April 2010 06:30 To: U2 Users List Subject: Re: [U2] Common Table Expressions 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 _______________________________________________ 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