[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

No Subject

I am trying to create the following query.
Need some help.

create a query for following.
-- for the particular bu,cust_id, item & item_ln,
if
item_seq_no is same and dst_seq_no is different
then
update the status as 'N' for higher dst_seq_no.
end-if

This is the sample data in the table which I am refering to.


BU      cust_id   item      item_ln  item_seq_no   dst_seq_no  status
---------------------------------------------------------------------
TGPTR   00081455  00600210      9       1               1       Y
TGPTR   00081455  00600210      9       1               2       Y
TGPTR   00081455  00600210      10      1               1       Y
TGPTR   00081455  00600210      10      1               2       Y
TGPTR   00081455  00600210      11      1               1       Y

Any Help would be Appreciated,
Thanks.

-- Deepak.


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com