|
this is similar to the sql that Rick sent earlier. It probably would not give me the result I wanted. Below is an example of detail record and what the result needs to be: Detail record 601 123 0001 JSN 601 123 0002 JSN 601 123 0003 JSN 601 123 0004 JSN 601 123 0006 BTD 601 123 0010 BTD 601 123 0011 JSN 601 123 0030 BTD 601 123 0044 BTD 601 123 0091 JSN 601 123 0092 JSN The result needs to be: 601 123 BTD 0006 - 10 601 123 BTD 0030 - 44 601 123 JSN 0001 - 04 601 123 JSN 0011 - 11 601 123 JSN 0091 - 92 -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Paul Morgan Sent: Friday, August 19, 2005 10:18 AM To: rpg400-l@xxxxxxxxxxxx Subject: Re: a need for speed Lim, You could use Query to create the summary. Order by Area Code, Prefix, Suffix, Terminal. Break level 1 on Area Code, Prefix, Terminal. Min & Max on Suffix. Output to a summary file. It won't let you output to your own file format. It will create a break level indicator field in the output file which you won't want. You also get a summary record with min and max on the Suffix over the entire file. But it does give you the detail you want. Paul
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.