Improved Split function
This improved Split function allows for multi-byte delimiters, optional null values, and optional null value substitution.
2007-09-10 (first published: 2007-05-01)
435 reads
This improved Split function allows for multi-byte delimiters, optional null values, and optional null value substitution.
2007-09-10 (first published: 2007-05-01)
435 reads
Sometimes you need to calculate a running sum. Uses of this include adding a Month-To-Date column to a query of recent orders. I haven't seen anyone publish how to do this before (using this method).This query works by using the Row_Number() function and recursive query capability of SQL 2005.
2007-07-16
518 reads
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
For the first workdays of this new year, I had the pleasurable task of...
To meet these requirements below, I came up with this SQL. Please evaluate my...
Hi I am following an article posted on sql server central on the...
Hello. I am a bit confused and not sure what terms to use to...