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 |
|
purdyra
Starting Member
7 Posts |
 Posted - 2011-05-31 : 17:25:58
|
| i have a table that haspo number fedex tracking #41014 123456, 45678, 8901241015 78903,23897,79879749372 7927393,3233,232323etc...I have used the splitlist function before but it's for only one column,how can i use it here or what else can i do,I need this to look like:41014 12345641014 4567841014 8901241015 7890341015 23897 etc...thank you for your help. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-05-31 : 17:41:56
|
| Try this: http://www.sqlteam.com/article/parsing-csv-values-into-multiple-rows |
 |
|
|
purdyra
Starting Member
7 Posts |
Posted - 2011-06-01 : 11:22:06
|
| thanks, that worked perfectly, it saved me a lot of headache. :-) |
|
|
|
|
|
|
split list for 2 columns