Jeffrey Williams


Fiscal/Retail 4-5-4 Calendar Function

This function returns a 3 year calendar based on a 4-5-4/5-4-4/4-4-5 calendar, also known as a 52/53 week calendar.  The basis of this calendar function was derived from the NRF retail calendar published at https://nrf.com/resources/4-5-4-calendar and the Wikipedia article published at https://en.wikipedia.org/wiki/4%E2%80%934%E2%80%935_calendar. The calendar function requires 2 helper functions.  The helper functions were derived from […]

2020-09-21 (first published: )

786 reads

Calculating Easter in SQL

Several months ago someone commented on a calendar thread that you should not even try to calculate Easter in SQL Server because the math was too hard.  That got me to thinking and I decided to see if that was actually the case. I found that there are several well known algorithms available - but […]

2020-04-06 (first published: )

1,088 reads

Blogs

Speaking at Data ANZ 2021

By

Looking forward to speaking at Data ANZ 2021 this weekend. Data ANZ "is the data...

Daily Coping 24 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

DDL Trigger to log database level security commands.

By

In my last post I talked about reasons why your permissions might go missing....

Read the latest Blogs

Forums

value for the max date group by id

By rohitkocharda

Hi everyone, I have data in my table as below date       ...

Cannot log in to new SQL server

By jcuello81

Hello, I'm fairly new to installing SQL 2019 standard and am having two issues....

Single Query Instead of a Cursor

By AMCiti

Is it possible to rewrite this routine to be a single query, instead of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers