
	Home > Microsoft .Net Development Tips > Microsoft SQL Server > SQL Tutorial: Number of business days between two dates

Win Development Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

MICROSOFT SQL SERVER

SQL Tutorial: Number of business days between two dates

Murthy Chamarthi
11.11.2003
Rating: -3.00- (out of 5)

Digg This!

StumbleUpon

Del.icio.us

This procedure in this SQL tutorial is useful to get the number of working days between the two dates given. It can be used to find answers to many questions such as the number of working days of an employee in an organisation. In our HRMS project, we need to calculate the actual leave days of an employee, excluding the holidays and weekends, and this script provides that. It has been tested on SQL Server 2000.

Reader Feedback

Bart H. writes: I think there's an error with the stored procedure code presented in this SQL tuto...

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Microsoft SQL Server
	Using the Visual Studio 2005 DataSet Designer to build a data access layer
	The CTE, the hierarchical query and SQL Server 2005
	SQL Server 2005 recursive functions and the CTE
	Choose the right .NET data provider, optimize application performance
	The fallacy of the data layer -- or, a new architectural model for software designs
	Book excerpt: ADO.NET and SQL Server 2005
	Addressing common SQL Server questions
	Book Excerpt: The .NET Framework and SQL Server 2005
	WinForms development using SQL Server 2005 and Visual Basic 2005
	Configuring ASP.NET 2.0 apps to SQL Server 2005 databases

SQL Server and .NET development

Microsoft releases new CTP of Oslo SDK

Perpetuum unveils database synchronizer for .NET 2.0

The CTE, the hierarchical query and SQL Server 2005

SQL Server 2005 recursive functions and the CTE

SQL Examiner Suite synchronizes data schema, sets

Book excerpt: ADO.NET and SQL Server 2005

DataDirect database drivers now support MySQL

Top .NET tips of 2007 (so far)

Addressing common SQL Server questions

Book Excerpt: The .NET Framework and SQL Server 2005

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

rial. It actually counts the number of Weekend days within the given date range.

Unless I've completely misunderstood, to get the weekdays, the counter should be incremented when the datepart function returned value is not equal to 1 or 7.

I tested the procedure using 1-Nov-2003 and 8-Nov-2003, which is from the first Saturday in November to the second. There are 5 business days in this range, the Busdays procedure returned 3, presumably the Saturday, Sunday and the following Saturday. If a business has been using this code, their calculations will be way out.

Rate this Tip
To rate tips, you must be a member of SearchWinDevelopment.com. Register now to start rating these tips. Log in if you are already a member.
Submit a Tip

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Database Programming Solutions - .NET XML, Visual Studio LINQ, ORM .NET

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2000 - 2009, TechTarget \| Read our Privacy Policy