Merry Christmas 2019

Question

Merry Christmas 2019

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
December 25, 2019 at 12:00 am

#3700808

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

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

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

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 1

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.

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

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 2

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.

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

kaspencer SSCarpal Tunnel Points: 4880 More actions · Answer 3

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: 736172 More actions · Answer 4

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.