On 2016/02/18 7:24 PM, David Bicking wrote: > Whatever mangled the text must have put a 2 in front of the 7, cause the copy > in my sent mail box has a 1 in front of the 7. I never got a copy of my > email from the mailing list, so I never saw the mangled version, just quotes > of it. I assumed you made the typo and didn't want to nit-pick someone trying > to help me. > > At any rate, Igor gave me the answer to my question, so unless someone comes > up with a different solution, the problem is solved. (in that sql is not a > good place to solve the problem...) > > Thanks, > David
It might well be my own introduced typo trying to unpack the garbled message, never be polite about an untruth! If the runs do work like Igor assumed, and there aren't 2 sets of A items inside of the I = 1 run, then the solution Igor posted will work quite well/efficient enough to be used (unless it's a high-stress environment). Simply test it first, if it is bad, try another way.
