在SQL Server中为一个日期范围订购(排名)季度

I very rarely use while loops in T-SQL reporting queries. In fact, this might be the only while look in our entire reporting system. Because of this, I have decided to check if anyone has a better way to solve the following problem. I very rarely use while loops in T-SQL reportin