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 |
|
davidpardoe
Constraint Violating Yak Guru
324 Posts |
 Posted - 2001-07-19 : 11:50:54
|
| OK, I know there are articles on this on the site but they don't quite do what I need...I have a table containing one field that holds a delimited string of text. I need to separate the string into separate fields.ie.Table1:-Field1======iue,ksdjj,jdj,ldkmmdmm,dkkd,jkkdk,hdhhushould become Table2Field1 Field2 Field3 Field4====== ====== ====== ======iue ksdjj jdj ldkmmdmm dkkd jkkdk hdhhuNote that I am working with 250 fields here and 3+million records!Please help - I've wasted nearly half a day on this! |
|
|
|
|
|
Translate CSV Field to Multiple Fields