Number of Weekdays between two dates - Set Based

Inspired by a post here at SQLServerCentral, I wrote this function to calculate the number of days between two dates that are weekdays. In order to achieve this I used a common SQL table that contains a sequence of number for 1 to X. This was used as an input to the datediff function, and […]

2004-12-24 (first published: )

286 reads

Blogs

SQL Clone Works with FILESTREAM

By

SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to...

Fun and profit with UTF-8

By

When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...

Data Platform MVP 2020

By

I am humbled to be among so many great professionals and honored at the...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

Database Modeling - Relationships

By ukashishgarg

Comments posted to this topic are about the item Database Modeling - Relationships, which...

Read database objects relationship in easy steps

By ukashishgarg

Comments posted to this topic are about the item Read database objects relationship in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers