this the record that i have let say MR_TABLE ________________________________ MR_NUMBER| ITEM_NUM| MR_STATUS| .----------.|----------.|.-----------.| MR_000045 | ITEM_001 | _APPROVED | MR_000045 | ITEM_023 | _APPROVED | -------------------------------------' MR_000112 | ITEM_045 | _DECLINED. | MR_000112 | ITEM_002 | _DECLINED. | MR_000112 | ITEM_015 | _DECLINED. | -------------------------------------' MR_000005 | ITEM_019 | _APPROVED | MR_000005 | ITEM_004 | _APPROVED | MR_000005 | ITEM_037 | _APPROVED | -------------------------------------'
when i generate new MR_NUMBER = 'MR_000185' That contained four items 'ITEM_001','ITEM_045','ITEM_099','ITEM_037'
i've some problem for the query. can you help me to show the record in MR_TABLE depend on 'MR_000185'(my new MR_NUMBER) items???
should i use cursor or what???? actually i don't know how to use cursor
this the result that i expected below the history record from my new MR_NUMBER 'MR_000185' items ________________________________ MR_NUMBER| ITEM_NUM| MR_STATUS| .----------.|----------.|.-----------.| MR_000045 | ITEM_001 | _APPROVED | MR_000005 | ITEM_037 | _APPROVED | MR_000112 | ITEM_045 | _DECLINED. | -------------------------------------' thanks for your help before
It is not clear. Can you elaborate with DDL and Expected output
sorry whay u mean about DDL ?
DDL(Data Definition Language) means table structures..
>>when i generate new MR_NUMBER = 'MR_000185' That contained four items 'ITEM_001','ITEM_045','ITEM_099','ITEM_037' how you are inserting these values into table...?
It is not clear. Can you elaborate with DDL and Expected output
sorry whay u mean about DDL ?
DDL(Data Definition Language) means table structures..
>>when i generate new MR_NUMBER = 'MR_000185' That contained four items 'ITEM_001','ITEM_045','ITEM_099','ITEM_037' how you are inserting these values into table...?
Using CURSOR or what ???
Posted - 01/03/2013 : 22:18:23
