Calculate gregorian easter sunday using a table valued function

Question

Post reply

Calculate gregorian easter sunday using a table valued function

robin.langell

SSC Rookie

Points: 46
More actions
August 22, 2014 at 10:42 am

#311019

Comments posted to this topic are about the item Calculate gregorian easter sunday using a table valued function

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

Faster than the usual algorithm I use. Here's a little tidyup:

;WITH

Step1 AS( SELECT a = @year%19, b = FLOOR(1.0*@year/100), c = @year%100),

Step2 AS( SELECT a,b,c,d = FLOOR(1.0*b/4), e=b%4, f=FLOOR((8.0+b)/25) FROM Step1),

Step3 AS( SELECT a,b,c,d,e,g = FLOOR((1.0+ b- f)/3) FROM Step2),

Step4 AS( SELECT a,d,e,h = (19*a+b-d-g+15)%30, i= FLOOR(1.0*c/4), k= @year%4 FROM Step3),

Step5 AS( SELECT a,h,l = (32.0+2*e+2*i-h-k)%7 FROM Step4),

Step6 AS( SELECT h,l,m = FLOOR((1.0*a+11*h+22*l)/451) FROM Step5)

SELECT easterSunday = DATEFROMPARTS(@Year, FLOOR((1.0*h+l-7*m+114)/31), 1+(h+l-7*m+114)%31)

FROM Step6

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden