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
STRING_SPLIT Basics–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition
As we all know there is already a lot of information available about SQL...
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition
As we all know there is already a lot of information available about SQL...
Forums
Migrate the SSIS Catalog in Just a Few Clicks
Comments posted to this topic are about the item Migrate the SSIS Catalog in...
Using HttpClient in SSIS Script Component with visual studio 2015 framework4.8
Hi, I'm using HttpClient in an SSIS script component to retrieve data from a...
TSQL: Create dynamic partition DataRange
Hello All I am facing difficulties to write a query to create partition. In...
Ask SSC