Temporary Tables and Statistics in Stored Procedures

  • Hany Helmy

    SSChampion

    Points: 13488

    Tony Bater (4/11/2014)


    I am happy to say I got this right, but not so sure about the reason!

    I didn't know the answer (so learned something here, and that's good), but worked it out from logic alone.

    If #1 was true, then none of the others could be, and as the question states that there are two true statements, then #1 must be false.

    If #2 was true, then so must #3 and #4, hence 3 true statements not 2. So #2 must be false.

    Leaving #3 and #4 as the two true statements.

    A good mental exercise, but not SQL:-)

    Good analysis.

  • TomThomson

    SSC Guru

    Points: 104773

    SQLRNNR (4/11/2014)


    thanks for the question

    +1

    Tom

  • This was removed by the editor as SPAM

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Great question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Ken Wymore

    SSCoach

    Points: 16565

    Great question. I had to do some research on this one. Learned a lot. Thanks!

  • Hardy21

    SSCrazy Eights

    Points: 9708

    KWymore (4/15/2014)


    Great question. I had to do some research on this one. Learned a lot. Thanks!

    +1

    Thanks

Viewing 6 posts - 16 through 21 (of 21 total)

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