Re: [sqr-users] Array Sort/Grouping Help

[Darrel Scott <darrel_1977@yahoo.com>]

George -
 
I'm not sure if your solutions will help. Let me apologize in advance if they 
do, but I can't see it.
 
My array already passes in the values I need. My problem is due to the way the 
data is set up, I will obtain multiple IDs with my initially "summed up" NBRs. 
I've tried every possible way I can think of to re-write my SQL to give me the 
results I need, but to no avail.
 
So for every #ID in my array, I need to add the values from their cooresponding 
#NBRs together. That new value (#NBR_SUM) along with the #ID will be then 
printed to an output file.
 
In other words, rather than printing:
*********************
#ID: 001
#NBR: 123456
 
#ID: 002
#NBR: 987456
 
#ID: 003
#NBR: 555444
 
#ID: 001
#NBR: 000111
*********************
 
....I need to see:
*********************
#ID: 001
#NBR_SUM: 123567 <--- NEW VALUE
 
#ID: 002
#NBR_SUM: 987456
 
#ID: 003
#NBR_SUM: 555444
*********************
 
I'm in the process of putting together a "bubble sort" as "The Dragon" 
suggested. But I'm always open to other possibilities.
 
Thanks,
Darrel

George Jansen <GJANSEN@aflcio.org> wrote:
So you have

K1 -> S1 -> ID1, ID2 ...
S2 -> ID1, ID2

K2 -> S1 -> ID1, ID2 ...
S3 -> ID4, ID5...
...

Is it possible that you are approaching this the wrong way around?
Perhaps instead of build the IN lists you need a three-way join, and a
series of ON-BREAK procedures. This would allow you to 

Failing that, what if you did a load lookup? 

1. Create a view of the unique IDs--in Oracle terms this might be
CREATE OR REPLACE VIEW unique_b_ids
AS
SELECT id, rownum as rn
FROM (SELECT id from b order by id);

2. Code your load-lookup
load-lookup 
name=b_ids
rows=????
table=unique_b_ids
key=id
return_value=rn

3. Then you can find out where in the array to stash your value (or add
it)
with 
lookup b_ids #id #idx


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

---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!

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