Viewing 15 posts - 241 through 255 (of 658 total)
ChrisM@Work (9/4/2013)
They don't yield the same result set using 2k8. The first query generates a different result set each time it's run.
I get the same result set every time,...
September 4, 2013 at 1:55 am
Rune Bivrin (9/3/2013)
Hugo Kornelis (9/3/2013)
sknox (9/3/2013)
Wow.Nobody's mentioned what I consider to be the biggest problem with this question yet.
You must have overlooked the things already mentioned about ordering by Rune...
September 3, 2013 at 7:04 am
Rune Bivrin (9/3/2013)
Also, strictly speaking the will both return the result sets in random order since there is no ORDER BY specified for the result set.
That's the reason I...
September 3, 2013 at 2:33 am
Maybe 126 people don't care about what points they score?
No, silly idea, can't be that :w00t:
September 3, 2013 at 2:24 am
The correct answer is surely 0, as they are normally US-centric humour so I always get them wrong
September 2, 2013 at 2:03 am
Danny Ocean (8/21/2013)
I love this function. It removes some overhead while adding multiple string.
And I hate it for exactly the same reason!
At last they've deprecated CONCAT_NULL_YIELDS_NULL but then spoil...
August 22, 2013 at 4:00 am
DugyC (8/16/2013)
as of now there are 3 people with more than 30,000 points and they are all showing as SSCChampion
If you follow the link given in the explanation you will...
August 16, 2013 at 4:35 am
John Mitchell-245523 (8/15/2013)But that's the whole point. The non-existent table isn't reachable, and so it doesn't fail.
No. It's not reached, so it doesn't fail. It can be reachable and...
August 15, 2013 at 8:22 am
wolfkillj (8/15/2013)
August 15, 2013 at 7:55 am
Good question, though even if you didn't know the answer the "choose 4" hints should give it away - I guess the 50% (!) getting it wrong didn't notice this.
The...
August 15, 2013 at 2:53 am
Steve Jones - SSC Editor (8/2/2013)we had some authors of questions complain people wait until the next day and then get the answer to boost their "points"
Let them, if...
August 5, 2013 at 2:11 am
Data_God (8/1/2013)
August 2, 2013 at 2:26 am
Steve Jones - SSC Editor (7/31/2013)
Our changes here were to try and get a cleaner, less cluttered look.
I can understand that. It's a shame therefore that the newsletter changes...
August 1, 2013 at 2:06 am
L' Eomot Inversé (7/30/2013)
Somehow it makes me wonder if perhaps ugly, boring, space-wasting layout are have become fashionable? .:crying:
I get the impression that some people saw the latest Microsoft "everything...
July 31, 2013 at 2:03 am
Viewing 15 posts - 241 through 255 (of 658 total)