Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-07-10 (first published: 2019-06-26)
661 reads
SteveH
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-05-01
789 reads
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-04-25 (first published: 2019-04-18)
615 reads
Blogs
Installing SQL Server on Windows? Don’t forget these two useful switches
A few days ago on Twitter I wrote: Couldn’t connect to new SQL Server...
Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes
Recently Microsoft released a Non-Root SQL Server 2019 container and that’s the default if...
DBA Myths: Is an identity column always unique, in order, and without gaps?
Identity columns are all over the place. Probably 80-90% of the tables I see...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
power shell script for add datetime to file
Hi, i would like to generate csv file with datetime through sql job with...
NOT Operator and NULLs
--test data declare @T table(a int null, b int null) insert @T(a, b) select...
Ask SSC