Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Get Item from Delimited List at Position Expand / Collapse
Author
Message
Posted Wednesday, March 9, 2011 8:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 29, 2013 2:54 PM
Points: 2, Visits: 50
Comments posted to this topic are about the item Get Item from Delimited List at Position
Post #1075983
Posted Thursday, March 10, 2011 5:55 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:42 AM
Points: 1,167, Visits: 2,652
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 »

Add to briefcase

Permissions Expand / Collapse