Remove multiple whitespace from a string: revise
This is a re-written function that the idea got from yesterday's script. This function used a recursive call to simplify the script.
2006-11-17 (first published: 2004-09-20)
210 reads
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 […]
2005-02-07 (first published: 2005-01-19)
367 reads
Blogs
Heading Font Weights and List View Toggles Arrive in Block Editor and WordPress 5.8
By todd-32417
With the WordPress 5.8 release, we're starting to introduce features that overall improve your...
My Application is Getting SQL Timeout Errors, But What Query is the Problem?
This is something that comes up time and time again. A developer or member...
Daily Coping 27 Jul 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
How to find islands and get max and min range values
I am trying to create groups for each Name and save the max and...
FISCAL_WEEK from 1 Jan till First Friday
Hi, We have one requirement. Wee need to create a fiscal_week column in SQL_server...
FISCAL_WEEK from 1 Jan till First Friday
Hi, We have one requirement. Wee need to create a fiscal_week column in SQL_server...
Ask SSC