T-SQL Sorting ChallengeCommented on: 5 years ago
(September 3, 2008)
First create a UDF (which uses the Numbers table to split up the val string)
CREATE FUNCTION dbo.t1_x
RETURNS varchar(8000) AS
DECLARE @s varchar(8000)
SELECT @s =...
The Logical Puzzle - 22 Aug 2007Commented on: 6 years ago
(October 15, 2007)
If switch A is on, turn it off and increment count,
otherwise toggle switch B
If switch A is off and you haven't turned it on before, turn it...
Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More