Great article. I look forward to the series.

Can you help me understand the difference in the Nested Loops operator between the first and second plan? Other than the...

And, a question on type casting. I notice you use explicit type casting with

Cast(Ceiling(Cast(YearDay as real)/Cast(7 as real))as int)

and similar functions. I...

Stefan,

Great article. I always enjoy seeing the set based alternatives to the iterative approach.

And, I love the math. I think...