The End

Question

Post reply

The End

Steve Jones - SSC Editor

SSC Guru

Points: 736291
More actions
December 31, 2014 at 12:09 am

#73580

Comments posted to this topic are about the item The End

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

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

manik_anu SSCrazy Points: 2377 More actions · Answer 1

Very nice question.... +1 😀

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 2

We often set a date to that max value in an ISNULL function when making comparisons to other dates. A null date in our system represents no date, used for a date range with no end.

Mike Hays SSCommitted Points: 1871 More actions · Answer 3

Interesting, learned about the Y2K38 bug today.

Happy New Years Everyone!!!

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 4

RK Mandava

SSCarpal Tunnel

Points: 4153

December 31, 2014 at 7:12 am

#1767178

Nice Question

Dana Medley SSCertifiable Points: 6764 More actions · Answer 5

Thanks for the question and thanks for a great 2014! :hehe:

Everything is awesome!

webrunner SSC-Dedicated Points: 31869 More actions · Answer 6

manik123 (12/31/2014)
Very nice question.... +1 😀

+2 😀

Thanks, Steve!

I wish everyone out there in SSC land a healthy and happy new year.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

ManicStar SSCoach Points: 17992 More actions · Answer 7

ManicStar

SSCoach

Points: 17992

December 31, 2014 at 9:38 am

#1767216

Nice Q, no googling required either 🙂

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Happy New Years to all

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 9

Nice question, I checked the answer just to be sure and realized that a nice wrong answer would have been June 6, 2079 which is the limit for smalldatetime. Mostly to include the reference in the explanation.

Nice detail on the year 2038 problem.

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 10

Easy one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Hany Helmy SSChampion Points: 13921 More actions · Answer 11

I remember i have read about this somewhere, so bicked the correct answer, thanx 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

xsevensinzx One Orange Chip Points: 25560 More actions · Answer 12

xsevensinzx

One Orange Chip

Points: 25560

January 7, 2015 at 11:29 am

#1768550

Woo!

You got it right!

rhythmk SSCertifiable Points: 7271 More actions · Answer 13

Thanks for question Steve.

--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂