Revise t-sql function to parse string data

Kmlakov's script, t-sql function to parse string data, posted on 1/19/2005, required the passing in text ends with the delimiter. But it is usually not the case. I rewrote the script (added one IF statement). The new script can treat the text with or without ending delimiter. The third parameter will be the number of […]

5 (1)

2005-02-07 (first published: )

365 reads


Regression Testing SQL Saturday Naming


I started a poll today on the naming for future SQL Saturdays. You can...

Daily Coping 9 Apr 2021


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

Error creating Azure SQL Database


A quick post today, quite simply, the error message is: “code”: “ConflictingDatabaseOperation”,  “message”: “Operation on server x and database y is in progress.  Please wait a few minutes before trying again.” What...

Read the latest Blogs


RunningTotal column not working

By luissantos

Hello, I need a little help with my query because they don´t work properly...

Splitting a group up into multiple groups using a score....

By Rob Reid-246754

Splitting a group up into multiple groups using a score for how many times...

Whether to leave a clustered index on a staging table

By DamianC

Hi Using dataflows to load data from one SQL table to another (seperate databases;...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers