Viewing 13 posts - 1 through 13 (of 13 total)
L' Eomot Inversé (10/31/2011)
Steve Jones - SSC Editor (10/31/2011)
It's a bit of...
November 1, 2011 at 3:07 pm
How is knowing this going to help me in my career?
Please let's avoid pointless questions like this in future! It was pointless, quite literally, for me...
October 31, 2011 at 3:02 am
Enjoyed that one.
Just a little surprised that the explanation seems a little brief and misses out the key point of precedence.
Whilst I wasn't sure what the precedence was,...
October 12, 2011 at 1:43 am
Oh dear. I got it right, but the answer said I got it wrong!
Incidentally, I'm running the dinosaur that is SQL Server 2005 and so I had to modify...
September 27, 2011 at 2:15 am
Hugo Kornelis (1/4/2011)
January 4, 2011 at 8:56 am
phil.wood 94423 (12/13/2010)
phil.wood 94423 (12/10/2010) My default schema is not dbo!
phil.wood 94423 (12/10/2010)
Most QOTD readers that actually run or test the QOTD scripts do so in a default...
December 15, 2010 at 6:19 am
Most QOTD readers that actually run or test the QOTD scripts do so in a default NON Production installation...
December 13, 2010 at 2:15 am
The code returns an error:
Msg 3701, Level 11, State 5, Line 1
Cannot drop the table 'dbo.NullOperation', because it does not exist or you do not have permission.
The table is created...
December 10, 2010 at 2:40 am
That'll teach me to shoot before I aim.
September 14, 2010 at 1:57 am
Oops, I got it wrong.
In my defence, nesting works all over Microsoft so I'm a little surprised they never got it working here. Almost seems like an oversight.
September 14, 2010 at 1:46 am
How about good ol' grouping to remove duplicates and supply any of the minimum, maximum, sum, count, average, etc. etc?
select ItemNumber, min(UnitCost) as MinCost from MissingItems
group by ItemNumber;
July 27, 2010 at 1:55 am
I agree - don't awaken the beast.
In the eyes of developers, cursors are like Marmite.
July 2, 2010 at 1:52 am
The author has made their mind up before putting this to press (as shown in the naming convention 'badCursor' and the article title 'Cursors Be Gone!').
The author has, however, totally...
June 18, 2010 at 2:34 am