I'm curious as well with so many WITH's. Please entertain us with the specifics of your query.
Performance wise, this offers the following question. If the first WITH fails and it's a bunch of ANDed WITH's, does the system continue to gather the other pass/fails despite the first failing and the rest are moot. I've streamlined many queries by dividing and conquering. Especially if some of the fields are heavier than the others, ie correlatives or translates. Not to mention any indexed fields. Thanks Mark Johnson ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <u2-users@listserver.u2ug.org> Sent: Monday, September 25, 2006 4:45 PM Subject: Re: [U2][UD] UniQuery SELECT WITH Limits > Not to second guess, but anytime someone says something about hitting one > of the limits, I have to think there is a better way of doing what you > want to do. > > Why don't you give us a little more detail as to what you are trying to > do? > > Bruce M Neylon > Health Care Management Group > > > > > "jjuser ud2" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 09/25/2006 03:21 PM > Please respond to > u2-users@listserver.u2ug.org > > > To > u2-users@listserver.u2ug.org > cc > > Subject > [U2][UD] UniQuery SELECT WITH Limits > > > > > > > Hi hello how are ya :) > > Limits. The documentation I have for "Using UniQuery" says that you > can only have 120 different "with" fields in a SELECT statement. I'm > trying to select a series of non-contiguous numbers at random > intervals to generate a select list. There are 251 of these numbers. > Do I have to split the list into three different groups in order to > generate three different lists that I can do a SAVE.LIST on? What's > the best way to go about getting these select lists? > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
