|
Thanks for your reply JohnWILL be the master record.
Maybe I kept this too simple, but yes, in this instance, the first record
Once I get the fundamental code in place, I have a LOT more to do.that have any of the non- blank values in any of the
Am I limited to SQL - if you have an RPG answer, then AWESOME
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
Subject: Re: Using SQL to group records with similar elements
On Thu, Jul 21, 2011 at 12:37 PM, Alan Shore <ashore@xxxxxxxx> wrote:
Using record key 00001 as a starting point, I need to group all records
records can only be (1) grouped with the first record or (2) not groupedoccurrences, EXCLUDING those records that have OTHER none blank values
Does this mean the first record is always the "master" and the rest of the
at all? Or is the situation more complicated?and all suggestions are welcome
Hopefully, what I am asking makes sense, AND is feasible As always, any
Are you limited to SQL?
This is kind of a fun problem. :)
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.