Delimited String Parsing and Evaluation Functions

Here's a quick and dirty function for parsing strings based on a delimiter (As in a varchar field with comma delimited text). I'm hoping for feedback on a more efficient means of doing this.Also,4 functions for comparing two delimited lists of strings. Many may ask why these are needed, but that's a very long explanation […]

2005-09-21 (first published: )

245 reads

Utility proc for updating (sub) sequence columns

This is a utility proc that I use a lot for datawarehouse transformation/load processing. This is a generic proc for resequencing an integer column in sorted order within a given key combination.Note that 'key' is used here in a general context and not specific, that is there doesn't have to be any keys or indexes […]

2004-10-12

73 reads

tighter approach to counting strings in strings

Saw Mike's routine for counting occurences of a string in a string and I thought I'd offer a simpler solution.Simply replace the occurence with null and use length differences as shown.NOTE: len may ignore trailing spaces, so this can be made more solid by adding some non printable char (less likely to interfere with operation) […]

2004-03-10

60 reads

Blogs

Covid Thoughts, So Far

By

I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write...

How to Think Like a Certification Exam at the PASS Professional Development Virtual Group

By

Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...

Deploy BACPAC to Azure Managed Instance failing from SSMS?

By

Recently I ran into an error when trying to copy a small database bacpac...

Read the latest Blogs

Forums

Advantages and Disadvantage using Temp Table or Fisical Table

By fransiscuscandra

Please share your thought about advantages and disadvantages for processing using temp table or...

Do people process data from beginning of time when there is data change?

By fransiscuscandra

This might be a beginner developer questions but need some clarifications. What is best...

Why would I want to use Compress and Decompress functions?

By VoldemarG

in what live operational or development situation /requirement would I want to use the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers