Get Item from Delimited List at Position

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Chad Casady » Get Item from Delimited List at Position

Get Item from Delimited List at Position

Rate Topic

Display Mode

Topic Options

Author

Message

Chad Casady

Posted Wednesday, March 09, 2011 8:57 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 29, 2012 2:52 PM
Points: 2, Visits: 49

Comments posted to this topic are about the item Get Item from Delimited List at Position

Post #1075983

nigel.

Posted Thursday, March 10, 2011 5:55 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:57 AM
Points: 1,163, Visits: 2,600

Another, usually faster, way of splitting a string is with a Tally (or numbers table) see Jeff Moden's article in my signature below.

Take a look at the method about three quarters of the way through the article, where he compares the loop method with the tally table method you will see that he inserts the results into a temporary table which includes an IDENTITY column. This IDENTITY value can be used in a where clause to get the nth item.

--
Nigel

Useful Links:
How to post data/code on a forum to get the best help
The "Numbers" or "Tally" Table - Jeff Moden

Post #1076163

« Prev Topic | Next Topic »

Permissions