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: )

247 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

Speaking at DataMinds Connect 2020

By

I’m delighted to announce I’ll be speaking again at DataMinds Connect this year, one...

SQLSaturday Auckland: Certification Exams Inside Out this Weekend!

By

Looking forward to virtually presenting at SQLSaturday Auckland 2020 this weekend! I'll be presenting...

Data Cleanup for WordPress Tags without a Plugin

By

Over the years I’ve had this blog, I’ve added lots of tags. In 15...

Read the latest Blogs

Forums

Operating system error 1117 (I/O device error)

By Anderso

Hi, I have 3 Hyper-V servers in  a cluster with a SQL2019 VM on...

how to add a second file share witness?

By snomadj

Morning all,   Within failover cluster manager, how do add a 2nd file share...

SELECT Statement BLocking

By VastSQL

Hi Experts, we have observed that the SELECT statements are causing from application which...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers