SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Split Semi-Comma Delimited Field
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bholmstrom
Yak Posting Veteran

USA
75 Posts

Posted - 06/28/2013 :  14:29:57  Show Profile  Reply with Quote
Good afternoon,

I have a table that has a field that has been populated with a set of values seperated by a semi-colon

Example:

Joyce Price; Sheslie Royster; David Norton

I 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
Flowing Fount of Yak Knowledge

3760 Posts

Posted - 06/28/2013 :  14:39:15  Show Profile  Reply with Quote
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/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000