The following example will return two columns (first name, last name) based on a single, concatenated, comma separated name. table —— name —— Chin, Cheryl Frank, Robert SELECT RIGHT([name], LEN([name]) – CHARINDEX(’,’, [name]) – 1) AS [first], LEFT([name], CHARINDEX(’,’, [name])-1)… Continue Reading
You may receive the following errors if you incorrectly alias your column names: Invalid column name No column was specified Check to make sure that your column names are encased in brackets and are not encased by quotes. Incorrect SELECT… Continue Reading
1 2 3 4 5 6 7 8 DECLARE @string varchar(50), @execSql varchar(1000) SET @string = ‘I like kittens’ SET @execSql = ‘INSERT INTO table (column) SELECT ”’ SET @execSql = @execSql + REPLACE(@string, ‘ ‘, ”’ UNION ALL… Continue Reading
Traditional arithmetic would tell you that 5.1 = 5.10. However, arithmetic can’t compare software versions such as 5.1 to 5.10, since 5.10 is the ‘newer’ version. The function below receives two version numbers and returns which of the two is… Continue Reading