sqldba2k6
Posting Yak Master
176 Posts |
Posted - 2007-05-07 : 20:15:51
|
Please help me in writing a query to import the comma separated data in a text file to sqlserver 2000.Below is the sample data from the text file.100,1,xx,yy,20030101100,2,21,t4,20030101100,3,2p,01,20030101100,1,xx,yy,20030102100,2,21,t5,20030102100,3,2p,01,20030102I want the output: 100,1,xx,yy,20030101,2,21,t4,20030101,3,2p,01,20030101100,1,xx,yy,20030102,2,21,t5,20030102,3,2p,01,20030102 |
|