Post reply

T-SQL Puzzle

  • January 3, 2017 at 12:12 am

    #320179

    Comments posted to this topic are about the item T-SQL Puzzle

  • January 3, 2017 at 1:28 am

    This was removed by the editor as SPAM

  • January 3, 2017 at 2:27 am

    #1920314

    You have to consider that this answer works only for case insensitive collation. If you have Case sensitive the second query will return just one row.

    Thanks

  • January 3, 2017 at 2:56 am

    #1920316

    Presumably one of the last two options was supposed to be Two and Two, otherwise they are both the same and there's only one answer that has Two for the second query (which meant that I could get it right without having a clue what FMTONLY meant)

  • January 3, 2017 at 7:53 am

    #1920385

    Didn't know about this one. Thanks.

  • January 3, 2017 at 8:41 am

    #1920401

    Really interesting - thanks!

  • January 4, 2017 at 3:33 am

    #1920558

    Nice 1 :w00t:

    Thanks
    SUrya

  • January 15, 2017 at 7:44 pm

    #1922848

    Nice easy question.
    I wonder why MS is advising not to use FMTONLY.

    Tom

  • January 17, 2017 at 7:05 am

    #1923160

    Thanks for the question. Now you only have to put the semicolon not on a new line, before I go insane 🙂

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

  • January 17, 2017 at 8:30 pm

    #1923317

    Koen Verbeeck - Tuesday, January 17, 2017 7:05 AM

    Thanks for the question. Now you only have to put the semicolon not on a new line, before I go insane 🙂

    You must really hate reading my code examples. 

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 10 posts - 1 through 9 (of 9 total)

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