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

T-SQL Function to Determine Holidays in SQL Server Expand / Collapse
Author
Message
Posted Wednesday, October 15, 2008 11:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 9, 2012 10:55 AM
Points: 3, Visits: 35
Comments posted to this topic are about the item T-SQL Function to Determine Holidays in SQL Server
Post #586720
Posted Monday, November 24, 2008 8:45 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 2:50 PM
Points: 95, Visits: 219
This is cool and all, but how often does Easter make that big of a difference to a business? How about a function for the holidays that most people actually get a day off for.
Post #607613
Posted Monday, November 24, 2008 10:16 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:26 AM
Points: 1,182, Visits: 1,971
The Title is completely misleading. "Date of Easter" formulas have been around for decades. It was one of my early computer science homework assignments.


(PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.
Post #607706
Posted Tuesday, November 25, 2008 10:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, August 7, 2009 5:46 PM
Points: 295, Visits: 67
Some meaningful variable names would go a long way toward making this readable.

============================================================
I believe I found the missing link between animal and civilized man. It is us. -Konrad Lorenz, Nobel laureate (1903-1989)
Post #608545
Posted Thursday, November 27, 2008 6:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 24, 2010 5:10 AM
Points: 2, Visits: 9
hi
thanks for coll function but when i tried to execute it i got an error
would you help me to solve this problem ?
the error is "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."
thanks
MiM
Post #609785
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse