SqlServer一季度查询

[删库到跑路]

每年的12月26号为开始时间，
12月26号到3月26号为一季度
3月26号到6月26号为2季度
6月26号到9月26号为三季度
9月26号到12月26号为四季度
这个怎么写，求大佬

[文盲老顾]

加个计算列 alter table tableName add 季度 as (case when month(dateField)=12 and day(dateField)>=26 then '四季度' when month(dateField)<3 then '四季度' when month(dateField)=3 and day(dateField)<26 then '四季度' when month(dateField)<6 then '一季度' when month(dateField)=6 and day(dateField)<26 then '一季度' when month(dateField)<9 then '二季度' when month(dateField)=9 and day(dateField)<26 then '二季度' when month(dateField)<12 then '三季度' when month(dateField)=12 and day(dateField)<26 then '三季度' else '' end )

[删库到跑路]

引用 1 楼 文盲老顾 的回复:

加个计算列

alter table tableName add 季度 as (case
when month(dateField)=12 and day(dateField)>=26 then '四季度'
when month(dateField)<3 then '四季度'
when month(dateField)=3 and day(dateField)<26 then '四季度'
when month(dateField)<6 then '一季度'
when month(dateField)=6 and day(dateField)<26 then '一季度'
when month(dateField)<9 then '二季度'
when month(dateField)=9 and day(dateField)<26 then '二季度'
when month(dateField)<12 then '三季度'
when month(dateField)=12 and day(dateField)<26 then '三季度'
else '' end
)

虽然不对，但是有思路了，感谢