Re: [GENERAL] complicated running aggregate

2010-06-24 Thread Sim Zacks
That's what I was afraid of :-( I'm currently on 8.2 We're planning on starting 9.0 testing very soon, so I may just leave it until then. Sim On 6/24/2010 5:23 PM, Greg Smith wrote: > > If you're on an earlier version, using a loop in a function is not a > bad approach. Getting the query right w

Re: [GENERAL] complicated running aggregate

2010-06-24 Thread Greg Smith
Sim Zacks wrote: I am trying to build a query with a running total, but it is a bit complicated...Currently I'm generating this information using a plpsql loop, but I would like to change it to an SQL query, if possible. It's hard to do a running total with the sort of requirements you have

[GENERAL] complicated running aggregate

2010-06-24 Thread Sim Zacks
I am trying to build a query with a running total, but it is a bit complicated. We have different stock for leaded and unleaded parts, but we also have one stock if it is lead free and can be used in a leaded process (lfb - lead free both). I have the following fields: id,fkey_id,partid, duedate, q