On 10/14/2015 4:49 PM, Don V Nielsen wrote: > What am I looking to do? Using a table X, I've built a summary table, > calculating a value called net_non_pieces. net_not_pieces is a qty of rows > from a group rows that needs to be recoded to a different value. So what I > want to do is for each group in X, look up the calculated value in > crrt_net_non, then grab the first net_non_pieces (sequenced, of course) and > apply a code to those rows, leaving the remaining rows alone.
It might help if you show the definition of X, a sample of data in it, and the desired result of the query over that data. I, for one, have difficulty following your description. -- Igor Tandetnik
