Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Assigning categories to values 2 Expand / Collapse
Author
Message
Posted Friday, May 17, 2013 9:23 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 8,573, Visits: 9,081
Nice question, good explanation. No SQL weirdness like that in yesterday's question, so much easier.

Hugo Kornelis (5/15/2013)
Dave62 (5/15/2013)
A minor typo in the explanation.
"... As soon as one evaluates to True, the corresponding ELSE is returned. ..."

ELSE should be THEN in that sentence.


and
hany.helmy (5/15/2013)
In the Explanation: "A CASE expression will always evaluate the WHEN clauses from top to bottom. As soon as one evaluates to True, the corresponding [ELSE] is returned."

I think it should be the corresponding [THEN] not else, correct me if I am wrong.


You are both absolutely right. Sorry for that mistake. Unfortunately, I am unable to change the explanation.

Steve will correct it for you if you ask him (private message works quite well for that) - it is better if simple errors in questions are fixed so that people who come across them later are not confused or misled.


Tom
Post #1454060
Posted Friday, May 17, 2013 11:56 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 10, 2014 3:25 PM
Points: 2,133, Visits: 867
Straightforward Question.

Thanks

David
Post #1454236
Posted Thursday, May 23, 2013 3:24 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 5, 2014 8:36 AM
Points: 926, Visits: 556
Easier question with lot more information.

--
Dineshbabu
Desire to learn new things..
Post #1455909
Posted Tuesday, May 28, 2013 2:59 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 8:03 AM
Points: 825, Visits: 319
Easy question for me. Dank je, Hugo.

Got bit by the evaluation of aggregates a while back and forgot about it so it's good to be reminded. Nogmaals hartelijk dank, Hugo.
Post #1457231
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse