Viewing 15 posts - 16 through 30 (of 110 total)
I particularly liked this question because I got it wrong but shouldn't have!
August 23, 2012 at 8:35 am
Starting with 0, not 1, is totally fair and not "tricky." This is something for which IT professionals should be on the alert every waking minute (even prior to...
August 23, 2012 at 8:32 am
Sorry to miss out on the 5 points but I do use QOTD as a way to judge my skills. Also, it is quite possible to select a wrong...
July 29, 2012 at 10:22 am
I read through the question a couple times, ignored the inconsistencies, learned about NULLIF(), and earned a point.
Ron, you can count me as one of your satisfied customers. Thanks...
July 27, 2012 at 3:10 pm
Thomas Abraham (5/22/2012)
...and writing reports that won't be looked at when the crisis of the moment is over...
I thought that was my job!
Interesting that the most basic of questions...
May 22, 2012 at 11:39 am
This series of questions has given me a good understanding of sequences. I hope I remember this if/when my company ever upgrades to SQL Server 2012. Thanks for...
May 4, 2012 at 7:39 am
I did not find it burdensome to manually sort the 10 values with pencil and paper.
I loved this question. I have never heard of WITH TIES and I was...
April 13, 2012 at 8:16 am
Great spackle, Jeff. Very clearly written. Shows the old dogs a new trick and the new dogs some old tricks. Discussion shows there are many ways to...
March 29, 2012 at 8:08 am
davidandrews13 (3/27/2012)
that's the reason why i thought it didn't matter if you specified SELECT *, or not - because it always expanded it out for me.
It appears to break out...
March 27, 2012 at 9:49 am
Peter Schott (3/19/2012)
--Also worth noting that if someone used comments within the...
March 19, 2012 at 2:57 pm
I can't relate to this debate at all. I'd be thrilled if a certain colleague used ANY kind of indentation to make his SQL code readible.
Can anyone recommend a...
March 19, 2012 at 2:40 pm
Rock-solid question thanks to Ron and his staff of reviewers!
February 29, 2012 at 10:21 am
bitbucket-25253 (2/16/2012)
The comments so far are in themselves a wonderful lesson.And for that I thank SQL Kiwi, Hugo Kornelis and others to numerous to mention.
This discussion...
February 17, 2012 at 8:19 am
John Mitchell-245523 (2/14/2012)
In any case, I don't agree that just because two statements are posted on the...
February 14, 2012 at 11:10 am
There's a whole lot of learnin' to be had in this one Q and explanation. Thanks!
December 27, 2011 at 7:50 am
Viewing 15 posts - 16 through 30 (of 110 total)