Merry Christmas 2019

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 720359

    Comments posted to this topic are about the item Merry Christmas 2019

  • Jeff Moden

    SSC Guru

    Points: 996807

    This is where a good analyst would ask for a more explicit meaning of what constitutes a "gift" or "present" and how they can be taken as some as being totally different from "items".  I obviously took the likes of 5 golden rings to be a single gift because the problem had the following definition in it...

    "The song presents A new gift during each of the verses."

    That would relegate to a the simple problem of being a Triangular Join which, in this case, would be solved by SUM(N) because of the WHERE clause against the Tally-table-structure.

    I agree that a Triangular Cube is the correct solution if you consider each item as a separate gift but that wasn't obvious in the question.

    Anyway, MERRY CHRISTMAS everyone!

     

    --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".
    "If "pre-optimization" is the root of all evil, then what does the resulting no optimization lead to?"

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

  • Jeff Moden

    SSC Guru

    Points: 996807

    p.s.  even that later definition (the one inferred by the supposed correct answer) may be incorrect.  We would also need to know if a partridge in a pear tree would actually have to be counted as 2 gifts. 🙂

    --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".
    "If "pre-optimization" is the root of all evil, then what does the resulting no optimization lead to?"

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

  • kaspencer

    SSCarpal Tunnel

    Points: 4407

    Nothing to do with the question, nor the fact that it is Christmas:

    Does anyone else find that the "Stay signed in" option has ceased to function over the past fortnight or so?

    Kenneth Spencer

    You never know: reading my book: "All about your computer" might just tell you something you never knew!
    lulu.com/kaspencer

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 720359

    kaspencer wrote:

    Nothing to do with the question, nor the fact that it is Christmas:

    Does anyone else find that the "Stay signed in" option has ceased to function over the past fortnight or so?

    Kenneth Spencer

    This is still working, and no problems reported. Cookies do expire with the new site after a month or so, but if you think this a real bug, please report this to the webmaster.

Viewing 5 posts - 1 through 5 (of 5 total)

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