Assigning categories to values 2

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    Comments posted to this topic are about the item Assigning categories to values 2


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Danny Ocean

    SSCertifiable

    Points: 6098

    Yesterday i learn something and today i got the chance test it. 🙂

    That's the best thing about QoD.

    Thanks Hugo.

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!
    www.GrowWithSql.com

  • Lokesh Vij

    SSChampion

    Points: 10836

    I found Today's question relatively easier than yesterday. 🙂

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • kapil_kk

    SSC-Insane

    Points: 21316

    Good question Hugo..

    Specially the link of CASE won't always evaluate in order 🙂

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • kapil_kk

    SSC-Insane

    Points: 21316

    Lokesh Vij (5/15/2013)


    I found Today's question relatively easier than yesterday. 🙂

    true 😛

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • WWDMark

    Hall of Fame

    Points: 3157

    kapil_kk (5/15/2013)


    Lokesh Vij (5/15/2013)


    I found Today's question relatively easier than yesterday. 🙂

    true 😛

    +1 to that but I was looking for a catch somewhere in the answers though (paranoid much!!) 😀


    MCITP
    MCTS - E-Business Card
    Twitter: WWDMark

    Try not! Do or do not, there is no try

    email: info@weekendwebdesign.co.uk
    Personal Website: www.markallen-online.co.uk
    Business Website: www.weekendwebdesign.co.uk

  • malleswarareddy_m

    SSCertifiable

    Points: 5847

    Easy one compared to yesterday QOTD. yesterday i got it wrong. i did not verify verify between operation -1 and -10.

    Malleswarareddy
    I.T.Analyst
    MCITP(70-451)

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    That is cool... how did you set two questions back to back? (if it was just out of luck then it is a strange luck....)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    Raghavendra Mudugal (5/15/2013)


    That is cool... how did you set two questions back to back? (if it was just out of luck then it is a strange luck....)

    People who submit questions have no control over when they will be published. When submitting questions, I often submit a few at the same time (because when I have an idea for a question, it very often grows big enough to be split into multiple questions). Usually, they are then published a week apart. Why the site managers decided to put these two back to back, I don't know.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Hugo Kornelis (5/15/2013)


    Raghavendra Mudugal (5/15/2013)


    That is cool... how did you set two questions back to back? (if it was just out of luck then it is a strange luck....)

    People who submit questions have no control over when they will be published. When submitting questions, I often submit a few at the same time (because when I have an idea for a question, it very often grows big enough to be split into multiple questions). Usually, they are then published a week apart. Why the site managers decided to put these two back to back, I don't know.

    🙂 any reason manager had... it worked out very well, and seeing these two in sequence is actually really great.

    Thank you, Hugo.

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Toreador

    SSChampion

    Points: 11222

    You should only rely on clauses evaluating in order when no aggregates are involved.

    Good job the question didn't include any of those or I'd have been scuppered!

  • sqlnaive

    SSCoach

    Points: 17435

    Because of yesterday's question, i was little afraid to check the answer but after wasting few minutes, found nothing fishy and locked my answer and bongo !!! 🙂

    Good second part this.

  • Skanker

    Hall of Fame

    Points: 3059

    Thanks for the questions. Got it wrong yesterday and right today so I must be learning something!!!:-D

  • Dana Medley

    SSCertifiable

    Points: 6764

    WWDMark (5/15/2013)


    kapil_kk (5/15/2013)


    Lokesh Vij (5/15/2013)


    I found Today's question relatively easier than yesterday. 🙂

    true 😛

    +1 to that but I was looking for a catch somewhere in the answers though (paranoid much!!) 😀

    +1. Great question, but I spent some time looking for the "got'cha" before answering.



    Everything is awesome!

  • This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 34 total)

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