Re: Manipulating Aggregate Function Values

["Bergeron, Marc, Herndon" <BergeronM@ALPA.ORG>]

                -----Original Message-----
                From:   Juan Alvarado [mailto:juan@GYSSA.COM.GT]
                Sent:   Tuesday, August 25, 1998 5:27 PM
                To:     Multiple recipients of list SQR-USERS
                Subject:        Re: Manipulating Aggregate Function
Values

                Thank you

                Marc

                Only you need to store in a column variable and use in
the code of SQR
                For example
                begin-select
                count &conteo
                        print &conteo (+1,1)
                        let #resp = &conteo * 1.25
                from sysobjects
                end-select

                I hope this help you
                Juan Manuel Alvarado
                CPS-DBA Sybase XI
                Gerencia & Sistemas Guatemala
                www.gyssa.com.gt <http://www.gyssa.com.gt>

                        > -----Original Message-----
                        > From: Bergeron, Marc, Herndon
[SMTP:BergeronM@ALPA.ORG] <mailto:[SMTP:BergeronM@ALPA.ORG]>
                        > Sent: Tuesday, August 25, 1998 2:43 PM
                        > To:   Multiple recipients of list SQR-USERS
                        > Subject:      Manipulating Aggregate Function
Values
                        >
                        > It's great to be able to use Aggregate
functions (MAX, SUM,
                        > COUNT(*).....) in SQR but how does one
multiply the resulting SUM() by
                        > -1 or PRINT COUNT(*).