The source system will send delimited string to my procedure. I need to convert them into table columns to process.
For example
the data for sply_reord_no and order_qty will come as '002R456,100|003Y678,200|093T88,10'
I need to convert this into
sply_reord_no ord_qty
------------------- ------------
002R456 100
003Y678 200
093T88U 10
Dear Experts
Please help.
Thanks in advance
Edited by: Saaya on Nov 12, 2010 10:47 AM