WorkDay Functions
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: 2019-09-04)
1,571 reads
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: 2019-09-04)
1,571 reads
2019-07-08
11,801 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
By Steve Jones
Today’s coping tip is to be gentle with yourself when you make mistakes. I...
I have a two-replica SQL Server Availability Group running on Windows VMs in the...
I have a SQL agent job which starts the trace (for audit purpose) everyday...
I have a number of databases on a sql server 2017 instance. For most...