Christmas 2017

Question

Post reply

Christmas 2017

Steve Jones - SSC Editor

SSC Guru

Points: 736183
More actions
December 23, 2017 at 2:01 pm

#77612

Comments posted to this topic are about the item Christmas 2017

Viewing 13 posts - 1 through 12 (of 12 total)

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

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

I could be incorrect but none of the answers are actually correct.

--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)

HappyGeek SSCoach Points: 18729 More actions · Answer 2

HappyGeek

SSCoach

Points: 18729

December 23, 2017 at 11:53 pm

#1973352

LOL, thanks Steve and Happy Christmas.

...

linda.gock 68050 SSC Rookie Points: 38 More actions · Answer 3

Jeff Moden - Saturday, December 23, 2017 3:37 PM
I could be incorrect but none of the answers are actually correct.

Is there also a missing "desc" for the order by?

Jeff Moden SSC Guru Points: 1004329 More actions · Answer 4

linda.gock 68050 - Sunday, December 24, 2017 3:16 PM
Jeff Moden - Saturday, December 23, 2017 3:37 PM
I could be incorrect but none of the answers are actually correct.
Is there also a missing "desc" for the order by?

Yep... that's it. Except I'm the only one missing it 😉 More coffee please. :blush::blush:

--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)

ancienteternity SSC Rookie Points: 46 More actions · Answer 5

SomeName in the ORDER BY would be correct... if it was an option.

kaspencer SSCarpal Tunnel Points: 4880 More actions · Answer 6

I've never heard of "Harry Potter and the Sorcerer's Stone". The nearest title to that which I know of is "Harry Potter and the Philosopher's Stone" which is the first in the Franchise. Maybe Steve made a misprint?

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

Really?

Book: https://www.amazon.com/Sorcerers-SORCERERS-Rowling-Jan-01-1999-Hardcover/dp/B007M81WZ0/ref=sr_1_3?ie=UTF8&qid=1514297829&sr=8-3&keywords=harry+potter+sorcerer%27s+stone
Film: https://www.amazon.com/Harry-Potter-Sorcerers-Daniel-Radcliffe/dp/B0011AQLZQ/ref=sr_1_2?ie=UTF8&qid=1514297829&sr=8-2&keywords=harry+potter+sorcerer%27s+stone

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 8

kaspencer - Monday, December 25, 2017 2:47 PM
I've never heard of "Harry Potter and the Sorcerer's Stone". The nearest title to that which I know of is "Harry Potter and the Philosopher's Stone" which is the first in the Franchise. Maybe Steve made a misprint?

Seem the American publisher had issues with the word "Philosopher" !
https://en.wikipedia.org/wiki/Harry_Potter_and_the_Philosopher%27s_Stone#U.S._publication_and_reception

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

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

Steve Jones - SSC Editor

SSC Guru

Points: 736183

December 26, 2017 at 8:33 am

#1973455

Crazy

Ed Wagner SSC Guru Points: 287026 More actions · Answer 10

J Livingston SQL - Tuesday, December 26, 2017 7:24 AM
kaspencer - Monday, December 25, 2017 2:47 PM
I've never heard of "Harry Potter and the Sorcerer's Stone". The nearest title to that which I know of is "Harry Potter and the Philosopher's Stone" which is the first in the Franchise. Maybe Steve made a misprint?
Seem the American publisher had issues with the word "Philosopher" !
https://en.wikipedia.org/wiki/Harry_Potter_and_the_Philosopher%27s_Stone#U.S._publication_and_reception

Movies are sometimes released in different countries with different names. I guess it's a fairly common practice. Personally, I loved the whole series. No matter what it was called, I'd call it great.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

kaspencer SSCarpal Tunnel Points: 4880 More actions · Answer 11

Ed Wagner - Friday, December 29, 2017 12:35 PM
J Livingston SQL - Tuesday, December 26, 2017 7:24 AM
kaspencer - Monday, December 25, 2017 2:47 PM
I've never heard of "Harry Potter and the Sorcerer's Stone". The nearest title to that which I know of is "Harry Potter and the Philosopher's Stone" which is the first in the Franchise. Maybe Steve made a misprint?
Seem the American publisher had issues with the word "Philosopher" !
https://en.wikipedia.org/wiki/Harry_Potter_and_the_Philosopher%27s_Stone#U.S._publication_and_reception
Movies are sometimes released in different countries with different names. I guess it's a fairly common practice. Personally, I loved the whole series. No matter what it was called, I'd call it great.

Ah, but I was referring to the book. And as you'll appreciate from the Wikipaedia story Ms Rowling was not happy with the changes anyway. In the UK we get loads of books published in US English, notwithstanding the fact that we therefore have nouns used as verbs, transitives as intransitives, and many other corruptions.

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

Stewart "Arturius" Campbell SSC Guru Points: 72625 More actions · Answer 12

Nice question, thanks Steve.
Have just come back from a week an a half in the bush (out of mobile reception, etc). Good to be back in civilisation again...

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