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

Date Calendar Expand / Collapse
Author
Message
Posted Thursday, July 22, 2010 2:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 01, 2012 2:42 PM
Points: 1, Visits: 23
I just inner joined the table and saw the power!!!
Great idea and amazing script.


Post #957593
Posted Thursday, July 22, 2010 5:05 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:54 AM
Points: 310, Visits: 577
Thanks. :)
Post #957670
Posted Thursday, January 13, 2011 6:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 18, 2014 7:44 AM
Points: 6, Visits: 507
Hello,
Has there been a revision to add and/or flag if it's a business day e.g. Y or N. This equates not holidays and weekends, preferably in the US. Please send the script.

Thanks
Post #1047217
Posted Thursday, January 13, 2011 7:01 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:54 AM
Points: 310, Visits: 577
Sorry, no. Life's been busy lately. Celebrating our first child. :) It's on the "to do" list though (which seems to be getting longer each day!). ;) I will post when there is an update though.
Post #1047241
Posted Thursday, January 13, 2011 8:23 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 4:32 PM
Points: 417, Visits: 724
This is mentioned in my post Calculate U.S. Holidays at [url=http://www.sqlservercentral.com/scripts/holiday/70424/][/url]. I just added a column is_workday to Sean's existing script, then made my holiday script. Hope that helps!

____________________________________________________________________________________________
Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
Post #1047326
Posted Thursday, January 13, 2011 8:27 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:54 AM
Points: 310, Visits: 577
Ah yes! I had forgotten about this script. Thanks Thordog! :)
Post #1047328
Posted Thursday, January 13, 2011 9:04 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 17, 2014 3:24 PM
Points: 60, Visits: 173
Thordog, very nice addition. I added holiday_name to it.
Post #1047374
Posted Thursday, January 13, 2011 9:30 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 4:32 PM
Points: 417, Visits: 724
Gitmo, cool! Sean did a great job on that table. I have programmers I show it to that still use SQL date functions against the table. The whole point is you don't need any dateadd or datediff with this table, good grief!

____________________________________________________________________________________________
Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
Post #1047393
Posted Thursday, January 13, 2011 9:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:54 AM
Points: 310, Visits: 577
LOL! I've seen the same thing!! When I show them how to properly use the table they're like, "Oh... OOOOHHHH!"
Post #1047408
Posted Wednesday, April 13, 2011 1:36 PM
SSC-Addicted

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

Group: General Forum Members
Last Login: Saturday, April 12, 2014 12:29 AM
Points: 419, Visits: 966
At the risk of exposing how much I might not know, why all the alter statements changing fields from tinyint to int, as well as NOT NULL? I would assume that the changing of populated columns to be NOT NULL helps performance, (and I'll be happy to read why if someone could point me to where to search for that hint) but why not define the int fields as int at table create?

Other than that, I have every plan to make use of this - kind of a Swiss Army Knife utlity table. Thanks in advance for the slightly off topic answer to my question.

Bob
Post #1093141
« Prev Topic | Next Topic »

Add to briefcase «««23456»»»

Permissions Expand / Collapse