更新 SQL 如下 :

CREATE TABLE TEST(A date,B int,C nvarchar(10))

CREATE TABLE BASE(id int,M int)

insert into BASE
values (1,-3000) 
,(2,-4000) 
,(3,-5000) 
,(4,-6000) 
,(5,-7000) 
,(6,-8000) 
,(7,-9000) 
,(8,-10000) 

方法 1:

select A,B,
--TempC,
case when rownum=1 and TempC<>'' then N'發' else N'不發' end as Email
from (
select ROW_NUMBER () OVER(PARTITION BY TempC order by A) as rownum,A,B,TempC
from (
select A,B,
--TempA,TempB,
case when TempA>TempB then TempA else TempB end as TempC
from (
select A,B,TempA,
case 
when B <-3000 and B>=-4000 then -3000 
when B <-4000 and B>=-5000 then -4000 
when B <-5000 and B>=-6000 then -5000 
when B <-6000 and B>=-7000 then -6000 
when B <-7000 and B>=-8000 then -7000 
when B <-8000 and B>=-9000 then -8000 
when B <-9000 and B>=-10000 then -9000 
when B <-10000 then 10000 end as TempB
from TEST
left join (
select AA,max(M) as TempA
from (
select id,M,
(select 
min(A) 
from TEST
where 1=1
and B<M
) as AA
from BASE
) as TableX
where 1=1
group by AA
) as TableY on TEST.A=TableY.AA
) as TableZ
where 1=1
) as TableU
where 1=1
) as TableV
where 1=1
order by A

DEMO

方法 2:

select A,B,
--TempA,TempB,TempC,
case when rownum=1 and TempC<>'' then N'發' else N'不發' end as Email
from (
select ROW_NUMBER () OVER(PARTITION BY TempC order by A) as rownum,A,B,TempC
--,TempA,TempB
from (
select A,B,
case when TempA<TempB then TempB 
when TempA is null then TempB
else TempA end as TempC
--,TempA,TempB
from (
select A,B,min(M) as TempB
from TEST
left join BASE on 1=1
where 1=1
and B<M
group by A,B
--
union 
select  A,B,null as TempB
from TEST
where 1=1
and B>=-3000
) as TableD
--
left join (
select AA,max(M) as TempA
from (
select id,M,
(select 
min(A) 
from TEST
where 1=1
and B<M
) as AA
from BASE
) as TableX
where 1=1
group by AA
) as TableY on TableD.A=TableY.AA
) as TableZ
) as TableU
order by A

DEMO