amrita


{ City } bangalore
< Country > india
* Profession *
User No # 10361
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 1
Questions / { amrita }
Questions Answers Category Views Company eMail




Answers / { amrita }

Question { 13134 }

hi all, i have 1 flat file having 10 rows. like:-

id name amt
100 a 100
200 b 200
100 n 300
400 p 3000
100 a 100
600 x 6000

Now i want to load half of this data into one flat file and
remaining in other flat file.like :-

flat file 1

id name amt
100 a 100
200 b 200
100 n 300
----------------------
----------------------
flat file 2

id name amt
400 p 3000
100 a 100
600 x 6000

Plz reply me ASAP.


Answer

Thanks to all,

But i want to store first half data in 1 table and another
half in another table. and with procedure i m getting
alternative data.

Is This Answer Correct ?    1 Yes 1 No