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)
206 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)
362 reads
Blogs
Fun and profit with UTF-8
When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...
Data Platform MVP 2020
I am humbled to be among so many great professionals and honored at the...
Daily Coping 12 Aug 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Removing TDE from a Database: Level 4 Stairway to TDE
Comments posted to this topic are about the item Removing TDE from a Database:...
Total of topN, total of other employees, total of all
I have a table which includes the columns Branch, Employee, Year, Sales and Revenue....
SSIS package to unix
I created files from SSIS to a share folder in windows. I want to...
Ask SSC