MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » August 2010

Re: Using SQL to "mix" the records in a file



fixed

If using SQL, try:
select timestampfield, recordtypefield from file order by 1, 2;
In the case of duplicate timestamp IDs, the record type (if A or B) will be
sorted.
If needed, you can use a CASE statement to derive the record type if it is
based on something unique in each record.

Thanks,
Loyd

On Mon, Aug 9, 2010 at 12:43 PM, Alan Shore <AlanShore@xxxxxxxx> wrote:


Morning all
sorry about the subject line, but I couldn't think of a better one
Here is my predicament

I have a test file with thousands of records, but basically 2 types
Record type A
Record type B

The key to this file is a timestamp field, however, the file is basically
one batch of record type A, followed by a batch of record type B (based on
timestamp)
How can I "mix/mingle" these types so that the sequence (by timestamp) is
A
B
A
B
A

it can be a group of A, a group of B, a group of A, a group of B
As long as there is a mixture
I've thought about this all morning to no avail, so if someone has any
ideas , it would be MUCH appreciated

Thanks in advance


Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact