How to Find the Start and End Dates for the Current Week (and more)
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
2022-07-13
2,638 reads
Date computation
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)
3,302 reads
2018-02-23 (first published: 2018-02-19)
133 reads
2017-12-29
1,074 reads
Compute Holiday Day of the Month for any Year
This script provides the day of the month for the standard bank holidays for any given year. This is especially useful for computing the workday after a holiday.
2017-05-24 (first published: 2017-05-10)
477 reads
Blogs
Setting up SQL Server 2022 s3 Object Storage Integration using MinIO with Docker Compose
In this blog post, I’ve implemented two example environments for using SQL Server 2022’s...
Daily Coping 12 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
My Toolbox - Greenshot
By Zikato
Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...
Forums
Help me design a correct simple table
I have a table like Diesel(id, supplier, operator, machine, taken_time, given_time) There are 2...
Error Grafana SQLWATCH
hello , I am looking for a Grafana expert to help me with this...
SQL Standard Confusion
Comments posted to this topic are about the item SQL Standard Confusion
Ask SSC