Ending 2017

Question

Post reply

Ending 2017

Steve Jones - SSC Editor

SSC Guru

Points: 734459
More actions
December 28, 2017 at 8:34 pm

#77190

Comments posted to this topic are about the item Ending 2017

Viewing 15 posts - 1 through 14 (of 14 total)

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

Matthias Kläy Ten Centuries Points: 1117 More actions · Answer 1

Matthias Kläy

Ten Centuries

Points: 1117

December 28, 2017 at 10:55 pm

#1973794

I get 2016-12-29 with the supposedly correct answer.

Louis Hillebrand SSCarpal Tunnel Points: 4970 More actions · Answer 2

Louis Hillebrand

SSCarpal Tunnel

Points: 4970

December 29, 2017 at 12:00 am

#1973795

This question is one year late, DBCC TIMEWARP() ??

Rune Bivrin SSCrazy Eights Points: 8441 More actions · Answer 3

One has to admire Steve's tenacity at getting questions slightly bent.:hehe:

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

HappyGeek SSCoach Points: 18726 More actions · Answer 4

Need to change date in query to 2018 to get what you required! But good question, thanks Steve.

...

Carlo Romagnano SSC-Insane Points: 22601 More actions · Answer 5

The 2nd and 3rd answer are equal.
I'm curious to know why someone chooses the second answer instead of the third or vice versa.
😀😀😀

HappyGeek SSCoach Points: 18726 More actions · Answer 6

Carlo Romagnano - Friday, December 29, 2017 1:59 AM
The 2nd and 3rd answer are equal.
I'm curious to know why someone chooses the second answer instead of the third or vice versa.
😀😀😀

+1

...

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

Carlo Romagnano - Friday, December 29, 2017 1:59 AM
The 2nd and 3rd answer are equal.
I'm curious to know why someone chooses the second answer instead of the third or vice versa.
😀😀😀

Right. So I figured neither of them were right, and now my choices were 2. I got it wrong anyway. I hate date arithmetic. :angry:

Except as noted above, the "right" answer gets the wrong date.

manik_anu SSCrazy Points: 2377 More actions · Answer 8

Question is correct...But answer is wrong...:) 😀😀😀

Manik
You cannot get to the top by sitting on your bottom.

Sreekanth B SSCertifiable Points: 6145 More actions · Answer 9

2nd and 3rd options are same and 4th option returns 2016. None of the above should be an option....

Steve Jones - SSC Editor SSC Guru Points: 734459 More actions · Answer 10

crazy. Not sure what I was thinking there. Question changed, points awarded back

Ed Wagner SSC Guru Points: 287024 More actions · Answer 11

I got to it after it was changed. I love date math.

Thanks for a good question and another good year of the site, Steve.

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

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

Steve Jones - SSC Editor - Friday, December 29, 2017 8:22 AM
crazy. Not sure what I was thinking there. Question changed, points awarded back

Sometimes it is good to be on PST and get the questions after corrections... Thanks, Steve!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Herp derp. I answered this thinking last day of the year since the topic was "ending the year" and i was not answering the question on the day that it was published. DOH

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Stewart "Arturius" Campbell SSC Guru Points: 72499 More actions · Answer 14

Nice, easy question, thanks Steve (also glad i could only answer this after corrections applied)...

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