Q&A for professional and enthusiast programmers
DECLARE @ date='2100-12-31' SELECT year(z|7^1),(datepart(y,z|7^1)+7)/8,z%8FROM(SELECT datediff(d,2,@)z)t