Solved

Query to find work days in a month

Posted on 2012-03-21
3
344 Views
Last Modified: 2012-04-09
In T-SQL is there a query I can use to get the number of work days in a month minus holidays
0
Comment
Question by:TClevel
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
sventhan earned 500 total points
ID: 37749604
check this out...

http://sql.dzone.com/news/get-business-days-and-working-

Make your own holidays table and join to this.
0
 

Author Closing Comment

by:TClevel
ID: 37825292
Thanks I was out of town
0
 

Author Comment

by:TClevel
ID: 37825296
Thanks I was out of town
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question