Christmas 2017 - Part 4

Question

Post reply

Christmas 2017 - Part 4

Steve Jones - SSC Editor

SSC Guru

Points: 734449
More actions
December 27, 2017 at 9:02 pm

#100965

Comments posted to this topic are about the item Christmas 2017 - Part 4

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

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

HappyGeek SSCoach Points: 18726 More actions · Answer 1

Cheers Steve but a bit of a typo in this one too, cut and paste have a lot to answer for!!

...

Rune Bivrin SSCrazy Eights Points: 8440 More actions · Answer 2

Very hard to know if 'Adult' refers to the Age or Genre for the movie "'s a wonderful life"...

Just because you're right doesn't mean everybody else is wrong.

sanya Ten Centuries Points: 1016 More actions · Answer 3

Hi Steve,

In the 4th row number of values is incorrect as there are only 4 values in it and there are 5 values in other rows. So we got the following error message:

Msg 10709, Level 16, State 1, Line 8

The number of columns for each row in a table value constructor must be the same.

If we insert an additional value (an arbitrary one) after 'George Bailey' then the query will produce the 'George Bailey' as a result in both cases if we order by genre or age.
See the attached screens:

So I think the "genre" is also a correct solution.

HappyGeek SSCoach Points: 18726 More actions · Answer 4

sandor.reti - Thursday, December 28, 2017 2:58 AM
Hi Steve,
In the 4th row number of values is incorrect as there are only 4 values in it and there are 5 values in other rows. So we got the following error message:
Msg 10709, Level 16, State 1, Line 8
The number of columns for each row in a table value constructor must be the same.
If we insert an additional value (an arbitrary one) after 'George Bailey' then the query will produce the 'George Bailey' as a result in both cases if we order by genre or age.
See the attached screens:

So I think the "genre" is also a correct solution.

I think if you use the corrected line for QOTD Part 3 the solution works out correct, I believe this is the same error as the previous question; the genre would then be "Classic" and not "Adult". Steve?

...

GaryV Hall of Fame Points: 3307 More actions · Answer 5

GaryV

Hall of Fame

Points: 3307

December 28, 2017 at 5:18 am

#1973691

'''s broken again

Luis Cazares SSC Guru Points: 183698 More actions · Answer 6

Rune Bivrin - Thursday, December 28, 2017 12:30 AM
Very hard to know if 'Adult' refers to the Age or Genre for the movie "'s a wonderful life"...

Adult is an age and not a Genre. Although, some might argue that Adult is a genre, but it's definitively not the genre for It's a Wonderful Life.
This is what I did to correct the data set.
SELECT * FROM ( VALUES ('Ebenezer Scrooge', 'A Christmas Carol', 'Old', 'Fiction', 'London'), ('Dumbledore', 'Harry Potter and the Sorcerer''s Stone', 'Very Old', 'Fantasy', 'Hogwarts'), ('Frosty', 'Frosty The Snowman', 'Infant', 'Animated', 'A small town'), ('George Bailey', 'It''s a Wonderful Life', 'Adult', 'Drama', 'Falls') ) AS a (SomeName, Movie, Age, Genre, Locale)

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 7

Well, I thought I corrected this yesterday. Apparently I must not have saved the changes. Code should be:

SELECT TOP 1 answer = SomeName FROM ( VALUES ('Ebenezer Scrooge', 'A Christmas Carol', 'Old', 'Fiction', 'London'), ('Dumbledore', 'Harry Potter and the Sorcerer''s Stone', 'Very Old', 'Fantasy', 'Hogwarts'), ('Frosty', 'Frosty The Snowman', 'Infant', 'Animated', 'A small town'), ('George Bailey', 'It''s a Wonderful Life', 'Adult', 'Classic', 'Bedford Falls') ) AS a (SomeName, Movie, Age, Genre, Locale) ORDER BY

Revenant SSC-Forever Points: 42467 More actions · Answer 8

Don't worry, Steve. As it was before the correction was good enough to figure out the correct answer. Thanks for the question!

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 9

Revenant - Thursday, December 28, 2017 12:36 PM
Don't worry, Steve. As it was before the correction was good enough to figure out the correct answer. Thanks for the question!

Cheers

Stewart "Arturius" Campbell SSC Guru Points: 72498 More actions · Answer 10

Nice one, thanks Steve (Glad i got to answer this after corrections applied)...

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”