March 9, 2011 at 8:57 pm
Comments posted to this topic are about the item Get Item from Delimited List at Position
March 10, 2011 at 5:55 am
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.
May 17, 2016 at 6:37 am
I getting all of these "list" scripts you wrote. Thanks.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy