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

249 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

75 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

62 reads

Blogs

Daily Coping 13 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Converting a SQL Server Docker image to a WSL2 Distribution

By

Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...

Everyone Run a SQL Saturday in 2021

By

With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....

Read the latest Blogs

Forums

Dua To Make Heart Soften +91-9783777879 molvi Abbotsford

By VADIC850

Dua To Make Heart Soften +91-9783777879 molvi Abbotsford Dua To Make Heart Soften +91-9783777879...

Shohar Ko Kabu Karne Ki Dua +91-9783777879 molvi Abbotsford

By VADIC850

Shohar Ko Kabu Karne Ki Dua +91-9783777879 molvi Abbotsford Shohar Ko Kabu Karne Ki...

Now Cure Evil Eye Using Ruqyah +91-9783777879 molvi Abbotsford

By VADIC850

Now Cure Evil Eye Using Ruqyah +91-9783777879 molvi Abbotsford Now Cure Evil Eye Using...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers