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 |
|
bholmstrom
Yak Posting Veteran
76 Posts |
 Posted - 2013-06-28 : 14:29:57
|
| Good afternoon,I have a table that has a field that has been populated with a set of values seperated by a semi-colonExample:Joyce Price; Sheslie Royster; David NortonI would like to seperate these into a single field temp table.The field contains random number of entries.Thank you in advance for your assistance.Bryan Holmstrom |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-28 : 14:39:15
|
| Use a string splitter - the best one out there is Jeff Moden's DelimitedSplit8K - which you can dowload from here: http://www.sqlservercentral.com/articles/Tally+Table/72993/ |
 |
|
|
|
|
|
Split Semi-Comma Delimited Field