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

EOMONTH - 1 Expand / Collapse
Author
Message
Posted Sunday, January 20, 2013 5:48 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:11 PM
Points: 5,571, Visits: 24,767
Comments posted to this topic are about the item EOMONTH - 1

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1409270
Posted Sunday, January 20, 2013 12:55 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 7:37 PM
Points: 21,215, Visits: 14,917
Thanks Ron



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 #1409300
Posted Sunday, January 20, 2013 9:15 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
Thanks Ron for another one on SS 2012!

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1409343
Posted Sunday, January 20, 2013 10:03 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, May 31, 2014 9:19 PM
Points: 1,128, Visits: 1,162
Thanks Ron .

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1409346
Posted Monday, January 21, 2013 12:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:24 AM
Points: 13,270, Visits: 10,148
Easy one, thanks
I selected the answers one could expect, because it would be pretty sad if they messed up a brand new function




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1409369
Posted Monday, January 21, 2013 12:15 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, July 24, 2014 3:05 PM
Points: 1,886, Visits: 785
Lokesh Vij (1/20/2013)
Thanks Ron for another one on SS 2012!


+1


Regards,
Rals
.
Post #1409370
Posted Monday, January 21, 2013 12:59 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: Today @ 3:12 AM
Points: 848, Visits: 1,922
good one.

(.. i didn't know the existence of EOMONTH till now; and the functions in the SQL mainly turn to pink color font by default, by seeing the T-SQL code initially felt like is this a trick question? and literally did the BOL search and yes.... there you are... and understood that the IFCodes needs updating to the 2012 keywords... )


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1409385
Posted Monday, January 21, 2013 1:21 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: Today @ 1:38 AM
Points: 826, Visits: 2,661
This question is better suited for www.GeographyCentral.com.

How does knowing the last day of February in 2016 have anything to do with SQL Server? I had to check a calendar in order to answer this question, books online was no good here.





The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1409396
Posted Monday, January 21, 2013 2:24 AM


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 @ 3:41 AM
Points: 3,859, Visits: 4,998
Good qurstion, Ron,
Thanks

Sean Pearce (1/21/2013)
This question is better suited for www.GeographyCentral.com.

How does knowing the last day of February in 2016 have anything to do with SQL Server? I had to check a calendar in order to answer this question, books online was no good here.



Point of note:
The EOMONTH function in Excel currently does not recognise leap years. Therefore, if this was an exact copy of the function as used in Excel, it would not work correctly.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1409430
Posted Monday, January 21, 2013 2:49 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: Today @ 1:38 AM
Points: 826, Visits: 2,661
Stewart "Arturius" Campbell (1/21/2013)
Good qurstion, Ron,
Thanks

Sean Pearce (1/21/2013)
This question is better suited for www.GeographyCentral.com.

How does knowing the last day of February in 2016 have anything to do with SQL Server? I had to check a calendar in order to answer this question, books online was no good here.



Point of note:
The EOMONTH function in Excel currently does not recognise leap years. Therefore, if this was an exact copy of the function as used in Excel, it would not work correctly.

Since when did SQL Server start copying Excel?




The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1409445
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse