Re: [sqr-users] Aggregate expressions

["the dragon" <ceprn@hotmail.com>]

Use less columns????

rewrite the query if it has 45 columns in a group by...



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)



----Original Message Follows----

Hey All,

We have this SQR job that used to run fine against Oracle but now fails when
running against Sybase saying that the limit on number of aggregate
expressions has been reached.

The query has abt 45 columns in the group by clause (don't even ask me why
:| ) so looks like Sybase cannot take that too well.

Is there a way to get around this?

Thanks,
Dev Rishi Sahani

_________________________________________________________________
Send instant messages to anyone on your contact list with  MSN Messenger 
6.0.  Try it now FREE!  http://msnmessenger-download.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users