Re: SQL - Current and Previous Status

Nope...a cursor is usually a bad idea. ;)

If you just wanted one at a time...

select ordnum, ordstat, ordseq
from orders
where ordnum = xxx
order by ordnum, desc ordseq
fetch first 2 rows only

Charles

On Tue, Jul 17, 2012 at 12:11 PM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

All orders. If I just wanted one, I could/should use a cursor, and a
FETCH PRIOR, right?

On Tue, Jul 17, 2012 at 12:10 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

Are you interested in only one order at a time?

Or do you want all orders?

Charles

On Tue, Jul 17, 2012 at 11:06 AM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

Ok...I have a file (ORDERFIL) that has an order number (ORDNUM), a
status (ORDSTAT), and a sequence number (ORDSEQ). The sequence number
is just a one up number - it's not the row number, and it's not
related to an order. However, it will be in order by status for an
order. For a given order number, I want to get the current status and
the previous status. I was thinking along the lines of a select work
order, and then another select (temporary table?) where I select for
that order number and order by sequence number descending. Does this
make sense? Any ideas?

ORDNUM ORDSTAT ORDSEQ
12345 Ship 15
23456 Build 18
12345 Build 13
34567 Process 12
23456 Process 11
12345 Design 05

So I would want to retrieve 12345, Ship, Build; 23456, Build, Process;
34567, Process.

TIA!
--
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.

--
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.

--
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.