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

TSQL Expand / Collapse
Author
Message
Posted Monday, April 13, 2009 3:27 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 1:13 AM
Points: 482, Visits: 118
Yes I do agree. But Answer is "NO". Why they have given "Yes" and explanation 'No'. Its totally contradiction.
Post #695610
Posted Monday, April 13, 2009 4:12 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Saturday, March 19, 2011 12:37 PM
Points: 603, Visits: 63
The answer is No, as the explanation describes, yet if you answer no it is incorrect?
How can this be?
Is there some secret I am missing here?
Post #695626
Posted Monday, April 13, 2009 6:03 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 9, 2014 4:10 PM
Points: 1,388, Visits: 239
Seems to have been an oversight. Answer is clearly No...
Post #695665
Posted Monday, April 13, 2009 6:15 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:33 PM
Points: 2,448, Visits: 408
The question is sort-of tricky. the real answer is "Indirectly" there are tricks to use rand() when you normally shouldn't be able to...
Post #695679
Posted Monday, April 13, 2009 6:15 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 9, 2013 5:08 AM
Points: 1,127, Visits: 603
No! Yes! .... Maybe? should be a third option then... As what a former poster said, it sounds like SQL Server has a female intuition inside :)

Ronald Hensbergen

Help us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/
-------------------------------------------------------------------------
2+2=5 for significant large values of 2
Post #695680
Posted Monday, April 13, 2009 6:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 22, 2014 4:56 AM
Points: 1,093, Visits: 2,617
I love it when the explanation contradicts the shown correct answer.......



_______________________________________________________________________
For better assistance in answering your questions, click here
Post #695696
Posted Monday, April 13, 2009 6:36 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:13 AM
Points: 2,878, Visits: 468
I agree. I think the correct answer is No...


Post #695699
Posted Monday, April 13, 2009 6:44 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 4:12 PM
Points: 2,007, Visits: 768
It appears the correct answer is determined using the RAND() function.
Post #695708
Posted Monday, April 13, 2009 7:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:38 AM
Points: 1,182, Visits: 1,972
Noel McKinney (4/13/2009)
It appears the correct answer is determined using the RAND() function.
Best explanation yet for the correct, er, incorrect answer!



(PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.
Post #695774
Posted Monday, April 13, 2009 7:34 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, January 12, 2012 12:05 PM
Points: 308, Visits: 126
I am assuming that this will be corrected in a while, with No being set to the correct answer?
Post #695784
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse