RE: [sqr-users] Need Some help in a SQR Select

["Knapp, Richard" <KnappR@umsystem.edu>]

Kaz,

You will need to have the RPM module installed. (RPM - Read Programmer's
Mind).  This comes at an additional cost from PeopleSoft but, as you can
imagine, is well worth it.  My advice - see if you can talk your manager
into it.

Failing that - get all the rows into an array and brute force all
combinations until you get the results you want.

Good lick.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Kaz.Narayanan@averydennison.com
Sent: Thursday, December 08, 2005 12:34 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Need Some help in a SQR Select

Hello All,

In my SQR, I am trying to select  a group of rows in PS  where the sum
of
the amounts match some dolor amt.
Example.

In PS ITEM table we have following fields.
 ITEM
Balance amt
BUSINESS UNIT

let us say I have the following values in that table

      ITEM        Balance Amt       Business Unit
Row1  XYZ         100.00                  ABC
Row2     LMN            125.00                  KLM
Rwo2  KKK         40.00             PPP

in my SQR, I am trying to select row 1 and row 2 where the total of
Balance amt is 140.00 here is my procedure

Begin-Select
item

from ps_item HAVING sum(bal_amt) = 140
group by    ITEM

END-SELECT

I am not fetching any row, I am expecting the SQL to iterate with in all
rows where
it addes some rows to itself and sees where the total equals 140.00

any suggestions would be highly appreciated.

Thanks
Regards


Kaz.



-----------------------------------------
The information transmitted is intended only for the person or entity
to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this
information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the
sender and delete the material from any computer.


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

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