Viewing 15 posts - 1,411 through 1,425 (of 3,047 total)
Went back and reread this question as it may be something my admin would be interested in.
April 20, 2016 at 6:47 am
Thanks for the question. Had to do a little research. Ended up reading a lot. These question do serve a good purpose.
April 20, 2016 at 6:44 am
Ed Wagner (4/19/2016)
Simple, but not as simple as yesterday's question. Thanks, Steve.
Yeah, those one-choice solution sets are tough.
April 20, 2016 at 6:40 am
paul s-306273 (4/19/2016)
Stewart "Arturius" Campbell (4/18/2016)
Nice, simple question to start the day, thanks Steve... nice and simple if you know.
Agreed.
April 20, 2016 at 6:40 am
webrunner (4/10/2014)
I just want to make one small comment. I ran the code below:
[font="Courier New"]SELECT OrderAmt,
IIF(OrderAmt > 200,
'High $ Order',
'Low...
April 20, 2016 at 6:34 am
Good basic info about CASE. I've never used IIF, always just CASE.
April 20, 2016 at 6:33 am
ZZartin (3/24/2016)
Shouldn't it be COUNT(DISTINCT Played) >= 3, in case some decides to play 'switch kick to the nuts'? 😛
Good point.
April 19, 2016 at 4:48 pm
pmadhavapeddi22 (4/19/2016)
webrunner (4/18/2016)
Toreador (4/18/2016)
Currently showing a 99% success rate?!?
How could someone get the question wrong? There is only one choice.
I guess maybe they clicked Submit without clicking the radio button...
April 19, 2016 at 4:46 pm
Hugo Kornelis (4/7/2016)
Stewart "Arturius" Campbell (4/6/2016)
Interesting, never thought of doing it that wayNice question, thanks Horia
Nor should you. In production code, I would always write out the explicit intent instead...
April 19, 2016 at 4:43 pm
I generally don't need to compare against time so I will often convert datetime to date before the compare. Fortunately I don't have to do this for large sets of...
April 19, 2016 at 4:38 pm
Degradable (4/19/2016)
This sounds dire, but...
April 19, 2016 at 6:51 am
This is scary stuff. And it can be just as devastating as taking real human hostages. This was a hospital with real people whose health, maybe lives, were in jeopardy....
April 19, 2016 at 6:50 am
Viewing 15 posts - 1,411 through 1,425 (of 3,047 total)