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
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
: 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
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
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker
Sent: Friday, 9 April 2010 10:36
To: U2 Users List
Subject: Re: [U2] Common Table Expressions
Precisely, I am pretty sure U2 Sql does not support ALL the capabilities
of a MS Sql CTE...
But I would
, 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