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 12»»

New Year's Math Expand / Collapse
Author
Message
Posted Wednesday, January 2, 2013 9:40 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:41 PM
Points: 1,304, Visits: 1,670
Comments posted to this topic are about the item New Year's Math
Post #1402165
Posted Wednesday, January 2, 2013 10:09 PM


SSC Eights!

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

Group: General Forum Members
Last Login: Monday, August 4, 2014 5:38 AM
Points: 941, Visits: 558
Nice one...nothing complex.. need to read the Qstn with patience...

--
Dineshbabu


--
Dineshbabu
Desire to learn new things..
Post #1402171
Posted Wednesday, January 2, 2013 10:36 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 4:53 PM
Points: 21,617, Visits: 15,271
Thanks for the question.



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 #1402179
Posted Wednesday, January 2, 2013 11:05 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
Yes, Patience is the key..

nice question.. too much to read though.


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1402185
Posted Wednesday, January 2, 2013 11:56 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: Today @ 8:10 AM
Points: 3,901, Visits: 5,068
Interesting question, thanks

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1402200
Posted Wednesday, January 2, 2013 11:58 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, April 7, 2014 1:30 PM
Points: 395, Visits: 89
Nice question Thanks.
Post #1402201
Posted Thursday, January 3, 2013 12:19 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:12 AM
Points: 1,745, Visits: 473
Nice question and great explanation - didn't know about the literals in the declaration, so thanks for that too.
Post #1402209
Posted Thursday, January 3, 2013 2:17 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:35 AM
Points: 1,733, Visits: 6,319
I got it right because although I couldn't be bothered working through the code, it was clearly adding lots of things to @NewYearsEve so the answer was never going to be either @NewYearsEve or @NewYearsDay. As there was no syntax error, that left only one possibility
Post #1402241
Posted Thursday, January 3, 2013 2:52 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:04 AM
Points: 1,654, Visits: 1,085
I got this one fine as I have done lots of date time manipulation in SQL and other languages, but I'll happily admit the explanation put an interesting new (for me) perspective on the DATEADD and DATEDIFF functions. Nice one, cheers.
Post #1402257
Posted Thursday, January 3, 2013 6:18 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, June 12, 2014 4:19 AM
Points: 701, Visits: 1,145
Thanks for the question.
Post #1402330
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse