Workdays

WorkDay Functions

  • Script

Functions to list the number of work days in period , determine if a given date is a work day, add work days to a given date.
Uses a table of holidays and a tally table.

2019-09-24 (first published: )

656 reads

Blogs

Prompt in ADS

By

Ever since VS Code and Azure Data Studio came out, people have been asking...

When Too Much is Not a Good Thing

By

Explore how to avoid unwanted results that oft occur due to lack of attention...

SSMS Tip: Vertical Text Selection

By

Occasionally, I’ll stumble across one of those neat tricks that makes me ask myself,...

Read the latest Blogs

Forums

Pivot or convert column to rows

By sqltester1

Hi All, I have table which stores all in single column, I want to...

Having trouble with simple select query where all ordere item statuses = shipped

By Goalie35

I'm trying to write a simple query but having trouble returning the correct results. ...

Question on Index

By sabarishbabu

Hello, In my Datamart having FactTable like below and planing to create a index...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers