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: Wednesday, October 29, 2014 7:27 AM
Points: 1,347, Visits: 1,717
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: Thursday, October 16, 2014 7:54 AM
Points: 965, Visits: 561
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:58 PM
Points: 17,854, Visits: 15,803
Thanks for the question.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 10:14 AM
Points: 4,050, Visits: 5,366
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: 2 days ago @ 1:42 AM
Points: 1,818, Visits: 502
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: Yesterday @ 11:09 AM
Points: 1,789, Visits: 6,513
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: Yesterday @ 3:00 AM
Points: 1,749, Visits: 1,150
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