November 4, 2011 at 4:49 am
Hi,
I am not getting it got to solve this. Single Ticket No is having two or more than two records, but displaying only at one record. I want to Update the Same Ticket No at the NULL areas just after it and before another Ticket Number starts.
Source Data:-
-----------------------------------
TICKET NOBUSINESS AREANET AMOUNTBASIC FAREAIRLINE TAXUATPCOMMISSION
180982809484270592841840002331
9160
80010
180982862184140613721520002297
6000
4000
9160
79490
180982905428202114729160806
6000
154000
6200
-----------------------------------
I need the RESULT in this manner:-
-----------------------------------
TICKET NOBUSINESS AREANET AMOUNTBASIC FAREAIRLINE TAXUATPCOMMISSION
180982809484270592841840002331
18098280949160
180982809480010
180982862184140613721520002297
18098286216000
18098286214000
18098286219160
180982862179490
180982905428202114729160806
18098290546000
1809829054154000
18098290546200
----------------------------------
regards
Palash Gorai
November 4, 2011 at 4:58 am
Here is in clear manner and in short...
Source Data:-
TICKET NO----NET AMOUNT
1809828094----84270
----0
----0
1809828621----84140
----0
----0
----0
----0
1809829054----28202
----0
----0
----0
RESULT:-
TICKET NO----NET AMOUNT
1809828094----84270
1809828094----0
1809828094----0
1809828621----84140
1809828621----0
1809828621----0
1809828621----0
1809828621----0
1809829054----28202
1809829054----0
1809829054----0
1809829054----0
Regards
Palash Gorai
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply