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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Alan,

Not sure I understand what you are trying to do....

If you ORDER BY timestamp, how is that not what you want?

Perhaps some more details with example data would be useful to
understand what you are trying to accomplish...

In the meantime, consider wthat with any supported version of the OS,
you can use the CASE statement in the ORDER BY clause....

Hope that helps!
Charles

On Mon, Aug 9, 2010 at 1: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.