Delimited String Parser

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 Jano Petras » Delimited String Parser

Delimited String Parser

Rate Topic

Display Mode

Topic Options

Author

Message

Jano Petras

Posted Wednesday, November 12, 2008 12:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 19, 2012 4:49 AM
Points: 5, Visits: 14

Comments posted to this topic are about the item Delimited String Parser

Post #601169

jcrawf02

Posted Wednesday, December 17, 2008 5:35 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:46 PM
Points: 2,561, Visits: 18,910

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 »

Permissions