Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

New Year's Eve Expand / Collapse
Author
Message
Posted Monday, December 30, 2013 9:22 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 6:29 PM
Points: 32,834, Visits: 14,975
Comments posted to this topic are about the item New Year's Eve






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1526655
Posted Monday, December 30, 2013 11:48 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 6:04 AM
Points: 3,517, Visits: 2,606
Easy QOTD to end the year on good note.

Thanks Steve and all for making the year wonderful and interactive with QOTD efforts. And a wish you a wonderful year ahead.
Happy New Year
Post #1526669
Posted Tuesday, December 31, 2013 2:22 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 7:30 AM
Points: 482, Visits: 842
Nice question to end the year.

Happy New Year all Family members

May 2014 bring joy with enjoy



Post #1526691
Posted Tuesday, December 31, 2013 6:14 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 7:47 AM
Points: 8,296, Visits: 8,750
Nice question.

I spent some time wondering whether the second option was really intended to have that "b" or not, but decided that as it would also need other changes to make it work it didn't matter.

Happy 2014, everyone.


Tom
Post #1526734
Posted Tuesday, December 31, 2013 6:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 10:57 AM
Points: 1,053, Visits: 537
It's interesting to point out that for the correct solution the starting date did not have to be Dec 31 but could have been ANY date within 2013.

Pretty slick there, Steve!



"...when ye are in the service of your fellow beings ye are only in the service of your God." -- Mosiah 2:17
Post #1526738
Posted Tuesday, December 31, 2013 7:13 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:12 AM
Points: 520, Visits: 548
Interesting question, I had to look close at that one.

Happy New Year Everyone!!!
Post #1526739
Posted Tuesday, December 31, 2013 7:14 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 11:49 AM
Points: 1,727, Visits: 1,254
L' Eomot Inversé (12/31/2013)
Nice question.

I spent some time wondering whether the second option was really intended to have that "b" or not, but decided that as it would also need other changes to make it work it didn't matter.

Happy 2014, everyone.

+1 The b kind of threw me off a little as well. Thanks for the great question to end the year on.




Yeah, uh huh, you know what it is. Everything I do, I do it big

Post #1526740
Posted Tuesday, December 31, 2013 7:17 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 21, 2014 8:44 AM
Points: 1,633, Visits: 2,038
Nice question. What is most interesting to me is why 23% (as of now) got it wrong.

I can see thinking that

select dateadd( ss, -1, datediff(yy, 0, @ThisDate) + 1 )

is the correct answer if you don't know that the year "0" is 1900. But, I don't see how you can know how to interpret parenthesis and still choose C or D.

Hope everyone has a great 2014! Our most eastern members are already there.


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1526741
Posted Tuesday, December 31, 2013 7:50 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 8:57 AM
Points: 937, Visits: 390
Very nice tricky question.
Post #1526749
Posted Tuesday, December 31, 2013 8:44 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 4:39 PM
Points: 20,485, Visits: 14,143
L' Eomot Inversé (12/31/2013)
Nice question.

I spent some time wondering whether the second option was really intended to have that "b" or not, but decided that as it would also need other changes to make it work it didn't matter.

Happy 2014, everyone.


I started doing the same thing and came to the same conclusion.


Happy New Year y'all




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1526770
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse