Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kris22
Starting Member
35 Posts |
 Posted - 2008-08-01 : 23:45:36
|
| Hi Guys,I have a file with comma delimitted. I want to insert into table with ascending order. Please see the file below41;1;M ;;;;400000;1;080707;080825;;;51;Y;080707;1;2010;30;BEBR00760000;400000;NM;;;;;;;;;;;;;;1;;;;42;DODGERS, VARIOUS;41;1; T ;;;;400000;1;080707;080825;;;51;Y;080722;2;1836;30;BEBR00760000;400000;NM;;;;;;;;;;;;;;2;;;;42;DODGERS, VARIOUS;41;2; T ;;;;0;1;080701;080701;;;51;Y;080701;2;1927;30;BEBR00760000;0;NM;;;;;;;;;;;;;;1;;;;42;DODGERS, VARIOUS;41;3;MTWTFSS;;;;0;10;080630;080706;;;51;Y;080630;1;0102;30;BEBR00760000;0;NM;;;;;;;;;;;;;;9;;;;51;Y;080630;1;2234;30;BEBR00780000;0;NM;;;;;;;;;;;;;;4;;;;51;Y;080630;1;0600;30;BEBR00840000;0;NM;;;;;;;;;;;;;;1;;;;51;Y;080630;1;1658;30;BEBR00760000;0;NM;;;;;;;;;;;;;;10;;;;51;Y;080630;1;2356;30;BEBR00760000;0;NM;;;;;;;;;;;;;;8;;;;42;ROS, 6A-6A;I was able to insert into table as it is.right now it is inserting like rows 41,51,42. But i want to insert likerows 41,42,51. I tried ascending order but it is inserting all in the ascending order. there are 3 groups in this file which starts with 41,51,42 and again 41,51,42 and so on. i want in the same order but i want 42nd row to be inserted after 41. Can you guys give me some idea?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-02 : 06:14:37
|
| duplicatehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107929 |
 |
|
|
|
|
|
|
|
Copy file to another table with ascending order