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

Delimited String Parser Expand / Collapse
Author
Message
Posted Wednesday, November 12, 2008 12:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 1, 2014 9:32 PM
Points: 5, Visits: 16
Comments posted to this topic are about the item Delimited String Parser
Post #601169
Posted Wednesday, December 17, 2008 5:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 6:55 AM
Points: 1,332, Visits: 19,319
Hey Jano, thanks for writing the article. Unfortunately, I think some of the code is formatted incorrectly, as I could not see it in the article.

Also, your solution works, but is limited to the number of values that you set in the function (9 in this case).

See this article on Tally tables for an alternate solution by Jeff Moden that will parse through an unlimited number of values without needing to loop:
http://www.sqlservercentral.com/articles/TSQL/62867/

Thanks again for your efforts, keep writing! :)

Jon


---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #621112
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse