Jeffrey Williams

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-03-31

34 reads

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-02-19

103 reads

Blogs

How to Think Like a Certification Exam at the PASS Professional Development Virtual Group

By

Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...

Deploy BACPAC to Azure Managed Instance failing from SSMS?

By

Recently I ran into an error when trying to copy a small database bacpac...

Daily Coping–3 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Read the latest Blogs

Forums

Why would I want to use Compress and Decompress functions?

By VoldemarG

in what live operational or development situation /requirement would I want to use the...

Updating data with recording old values - thought process

By ucltech

Client has a projections table that sales reps can update on their own.  They...

Replacing / Removing All Text In Multiple Sets of Characters in SQL

By mnovosel

One of the result fields has multiple html references in it such as in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers