Re: Row Numbers

Hi Cindy,
it seems you have the same problem as I do, although I have to acknowledge that you have gotten much further in bringing the problem to its roots. (See Q:view with parameters)

Having said this, if you have a solution. pls let me know. I have tried all sorts of selects, decodes, unions & joins and I don't really see a decent way to do this. One idea would be to use a function that returns the row_number. Only problem is, that you will only have account_nr as a parameter when you do your select. So the function needs to keep its state someplace else, like in a table with account_nr and max_row_nr as columns. This might be dangerous when several people try to access the function at the same time.

More ideas, anybody?

Regards,
Boris Kraft
-
you may reply to kraft at open.ch, as devnull is no valid address at Open Systems.
this is to minimize spam
-

cindyclayton_at_att.com wrote in message <7c13e5$eo5$1_at_nnrp1.dejanews.com>...
>I am going to pull multiple rows of data for each account_nr. What I need
to
>do is also bring a row number but I need to reset this for each account_nr
>group. For example..
>
>account_nr dollars Row
>0000123 $100.00 1
>0000123 $150.00 2
>
>0000456 $200.00 1
>0000456 $250.00 2
>0000456 $350.00 3
>0000456 $ 75.00 4
>
>0000789 $225.00 1
>
>etc...
>
>Help will be appreciated!
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Mar 09 1999 - 06:26:29 CST