CASE vagaries

Question

Post reply

CASE vagaries

Viewing 15 posts - 16 through 30 (of 33 total)

You must be logged in to reply to this topic. Login to reply

mrpaulandrew Mr or Mrs. 500 Points: 552 More actions · Answer 1

Thanks Hugo, feeling much better after reading your post. Thought I had Monday morning madness.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 2

I appreciate the effort of the OP to submit this question.

However, I don't see how the OP could have thought that one of the answers given was correct, had they actually run the code.

Hopefully we all learned something today, and the OP's next question will be better.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Scott Arendt SSCrazy Eights Points: 8218 More actions · Answer 3

Look at it from the positive side - at least the official correct answer was still the "least incorrect" option.

Yep, that's why I chose it. When in doubt choose the least incorrect answer.

Julie Breutzmann Hall of Fame Points: 3637 More actions · Answer 4

sknox (9/9/2013)
david.gwalter (9/8/2013)
First time I have come across a question with an incorrect answer.
A little disappointing for a novice like myself.
I find that even for questions that are well and correctly written, the discussion holds additional information. So it's almost always worthwhile to read the discussion, even if the question is poorly written. I treat the questions as more of an introduction to a topic of the day.
I also try to keep in mind that the questions are written by the community, and so will reflect the varying levels of knowledge and skill out there.
Having said that, question authors should at least run the code they write and make sure that their answer is correct in that respect.

+1

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

I suspect that the intention was to demonstrate that ISNULL will pick up the first datatype in the list which in this case is char(1). Therefore the value of returned from the isnull would only be the first character in the longer string. It is interesting that the title refers to CASE when what is seems the user is evaluating is the knowledge of how ISNULL works.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

udayroy15 Ten Centuries Points: 1076 More actions · Answer 6

udayroy15

Ten Centuries

Points: 1076

September 9, 2013 at 7:58 am

#1648548

Actually the answer is: @X is now A<

chobson Newbie Points: 7 More actions · Answer 7

I agree. None of the the answers, A, B, C, or D, are correct. Because the ISNULL uses the data type of @x (Char(1)). The correct answer is '@X is A<'

ssimmons 2102 SSCommitted Points: 1634 More actions · Answer 8

I keeped looking at this one tying to get one of the answers. Got lucky and just picked the closest one.

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 9

A poor question, and incorrect answers. My apologies. I know I ran the code, but I'm guessing I didn't examine the answers closely enough.

I have updated the answers and awarded back points.

RossRoss SSCommitted Points: 1672 More actions · Answer 10

Steve Jones - SSC Editor (9/9/2013)
I have updated the answers and awarded back points.

I was just about to say, don't know what everyone is talking about, the correct answer is there, I even double checked it in SSMS! Thanks Steve.

Miles Neale SSChampion Points: 13147 More actions · Answer 11

Ross.M (9/9/2013)
Steve Jones - SSC Editor (9/9/2013)
I have updated the answers and awarded back points.
I was just about to say, don't know what everyone is talking about, the correct answer is there, I even double checked it in SSMS! Thanks Steve.

+1 Some times it pays to come late to the game.

😀

Not all gray hairs are Dinosaurs!

Ken SSCoach Points: 17191 More actions · Answer 12

Miles Neale (9/9/2013)
Ross.M (9/9/2013)
Steve Jones - SSC Editor (9/9/2013)
I have updated the answers and awarded back points.
I was just about to say, don't know what everyone is talking about, the correct answer is there, I even double checked it in SSMS! Thanks Steve.
+1 Some times it pays to come late to the game.
😀

+1

TomThomson SSC Guru Points: 104773 More actions · Answer 13

Steve Jones - SSC Editor (9/9/2013)
A poor question, and incorrect answers. My apologies. I know I ran the code, but I'm guessing I didn't examine the answers closely enough.
I have updated the answers and awarded back points.

Glad to see it's right now.

Tom

Revenant SSC-Forever Points: 42467 More actions · Answer 14

I am glad I got to answer this one after it was corrected. 😉

thava SSCrazy Points: 2275 More actions · Answer 15

learn a new thing today don't know that is null work in that way

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]