Oops, I appear to have removed Sergiy's comment about Easter 2021 as being a holiday!  I meant to hit Quote not Report!

In response, Easter 2012 might be a holiday where...

This is the main table definition, I warned you it was insane. 😉

CREATE TABLE dbo.tblCalendar (PKDate DATE NOT NULL
        ...

It's a good question. I don't get to decide, the business do. The rules are arbitrary so I have to use a fixed table, in fact several. This (table calendar445)...

@jeff - for some reason the post you quoted in your previous post isn't showing the quote. Your reply to me is though! When I view in Gmail...

@jeff - I didn't think I was using an incremental rCTE?

@Jeffrey - I did try and and d/l a couple of scripts, but I couldn't get them to...

I was pointed to this thread by the OP, Simon, a colleague of mine.  It's that time of year where we start to look at tables used in various databases...

• This reply was modified 4 years, 1 month ago by  David Jackson.
• This reply was modified 4 years, 1 month ago by  David Jackson.

This is a limited attempt at this requirement.  It does not...

• This reply was modified 4 years, 5 months ago by  David Jackson.

Ha! Version 4.21a was my first taste. Crikey, I feel ancient. ANSI-89 style may have been a standard back in the day, but has long been supplemented. In fact it...

Hello

Returning to this, I and another co-worker have collapsed the 3 CTEs above into one statement.  Here's an example

DECLARE @Date DATE = '2019-04-01 00:00:00';

SELECT @Date, DATEADD(
 ...

• This reply was modified 5 years, 5 months ago by  David Jackson.
• This reply was modified 5 years, 5 months ago by  David Jackson.
• This reply was modified 5 years, 5 months ago by  David Jackson.