Jeff Moden

  • Interests: SQL. When Im not having fun with that, then SQL. ;-)

SQLServerCentral Article

Calculating Work Days

How many times have you wished that there was a parameter for DATEPART to allow you to check for workdays? While many of us may get stuck working 6 or 7 days a week, most of the world revolves on a 5 day work week. Monday through Friday. New author Jeff Moden brings us a method of easily calculating the number of workdays between any two dates.

4.89 (38)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

70,621 reads

Blogs

What to Know about Power BI Theme Colors

By

Power BI reports have a theme that specifies the default colors, fonts, and visual...

A Global Team Meeting

By

The last few years at Redgate we’ve had the entire (or most) of the...

A New Word: sayfish

By

sayfish – n. a sincere emotion that seems to wither into mush as soon...

Read the latest Blogs

Forums

What Do You Want to Learn?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What Do You Want to...

How to Rename a Column in SQL Server

By Nisarg Upadhyay

Comments posted to this topic are about the item How to Rename a Column...

Disable Memory Grant Feedback Persistence

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Disable Memory Grant Feedback Persistence

Visit the forum

Question of the Day

Disable Memory Grant Feedback Persistence

In SQL Server 2022, how can I disable memory grant feedback persistence?

See possible answers