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


Prompt in ADS


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

When Too Much is Not a Good Thing


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

SSMS Tip: Vertical Text Selection


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

Read the latest Blogs


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


SQL Server Q&A from the SQLServerCentral community

Get answers