Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Business Days Rss

   Items 1 to 4 of 4   
 

BusinessDaysToCalendarDays (For Unusual Business Weeks)

Tells how many calendar days are needed to complete a number of bussines days starting in a defined day of the week.   Read more...
By Adrian Facio 2012/07/23 | Source: SQLServerCentral.com | Category: business days
Rating: |  Discuss |   Briefcase | 690 reads

BussinesDaysToCalendarDays

Tells how many calendar days are needed to complete a number of bussines days starting in a specified week day. Any comments? Let me know =D.  Read more...
By Adrian Facio 2012/07/20 | Source: SQLServerCentral.com | Category: business days
Rating: (not yet rated) |  Discuss |   Briefcase | 796 reads

SQL Function : Find ‘X’ Business Days in the Future

Many of us deal in date calculations and separating business days from calendar days is always a challenge. New author J Gravelle brings us a new article that talks about this subject as a way of ensuring SLAs are met.  Read more...
By J Gravelle 2009/02/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 9,985 reads

Count Business Days

Using a few constants and a few numeric properties found in two days, calculate the number of workdays between two days.  Read more...
By Megan Beebe 2008/07/18 | Source: SQLServerCentral.com | Category: datediff
Rating: |  Discuss |   Briefcase | 1,485 reads
   Items 1 to 4 of 4   
 
Tags
business week (2)    
calendar days (2)    
work days (2)    
calendar weeks (1)    
datediff (1)    
t-sql (1)