Click here to Skip to main content
15,890,690 members
Articles / Database Development / SQL Server

Holidays Table and GetWorkDays Function in SQL Server

Rate me:
Please Sign up or sign in to vote.
5.00/5 (2 votes)
6 Nov 2020CPOL 24.5K   193   3  
Fast function that excludes weekends and holidays
This article will show how to create a Holidays table and how to use this table to get the number of workdays between two dates.

Views

Daily Counts

Downloads

Weekly Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Web Developer
United States United States
Igor is a business intelligence consultant working in Tampa, Florida. He has a BS in Finance from University of South Carolina and Masters in Information Management System from University of South Florida. He also has following professional certifications: MCSD, MCDBA, MCAD.

Comments and Discussions