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 ««12345»»»

T SQL Expand / Collapse
Author
Message
Posted Wednesday, May 27, 2009 1:07 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:08 AM
Points: 2,365, Visits: 1,846
I wonder how most of the people got the right answer. 55% when i checked.

"Keep Trying"
Post #723819
Posted Wednesday, May 27, 2009 1:24 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 2,114, Visits: 5,501
Chirag (5/27/2009)
I wonder how most of the people got the right answer. 55% when i checked.


It was clear that answer number 1 had a type. Since the other answers were wrong, I was left with the answer with the typo and got it right.

Adi



--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #723832
Posted Wednesday, May 27, 2009 1:26 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 5:49 AM
Points: 1,470, Visits: 8,359
Well it's obvious that there's something awry here, as an awful lot of people are getting the same (but apparently incorrect) answer.
What version of SQL Server (including Service packs) was this tested on?


BrainDonor
Linkedin
Blog Site
Post #723835
Posted Wednesday, May 27, 2009 1:30 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 5:47 AM
Points: 1,065, Visits: 245

Made the obvious mistake myself.

My assumption:
1 Not correct
2 Not correct
So it had to be 3 without examining this answer properly.

Reminded me to not jump to conclusions to early!
Always check everything.

Leo
Post #723837
Posted Wednesday, May 27, 2009 2:00 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:56 AM
Points: 1,614, Visits: 903
Darn.

I should know better than to bother with questions where I struggle to read the options!
Post #723851
Posted Wednesday, May 27, 2009 2:20 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: Friday, July 16, 2010 2:10 AM
Points: 863, Visits: 295
Leo Hesen (5/27/2009)

Made the obvious mistake myself.

My assumption:
1 Not correct
2 Not correct
So it had to be 3 without examining this answer properly.

Reminded me to not jump to conclusions to early!
Always check everything.

Leo


Me too, I must read all the questions completely before jumping to conclusions - doh!
Post #723859
Posted Wednesday, May 27, 2009 2:43 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, October 9, 2014 9:03 AM
Points: 821, Visits: 733
Leo Hesen (5/27/2009)

Made the obvious mistake myself.

My assumption:
1 Not correct
2 Not correct
So it had to be 3 without examining this answer properly.

Reminded me to not jump to conclusions to early!
Always check everything.

Leo


I did exactly the same as you. It's always reassuring to see other people making the same mistakes as myself - makes me feel a bit less stupid.txtPost_CommentEmoticon('');


--
Scott Doughty
Post #723873
Posted Wednesday, May 27, 2009 5:40 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 6:53 AM
Points: 484, Visits: 831
So I'm not the only one thinking the options given are wrong!
Post #723974
Posted Wednesday, May 27, 2009 5:45 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 2,917, Visits: 2,531
Amazing, I ran the code which supposedly has a typo, and the results were:
Em Ma
---------- ----------
Vyas Mohan
Mohan Shobha
Shridhar Mohan
Sourabh Mohan

(4 row(s) affected)

I must have read too fast.

Was the question tested and verified before it was posted?


Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Post #723977
Posted Wednesday, May 27, 2009 5:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 8, 2011 8:55 AM
Points: 274, Visits: 149
Like everyone else seems to have, i discarded the first answer because there was NOT a second name in the third row. Yes I understand it's a typo but as it stands there is not a correct answer to choose from. I would have an issue with a developer that made the assumption that was what the end user meant instead of verifying it. (I know that would never happen in production. Right? )
Post #723981
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse