SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE TEST(A date,B int,C nvarchar(10))
insert into TEST
values ('2019/10/1',	-3200,	'' ) 
,('2019/10/2',	-3600,	'' ) 
,('2019/10/3',	-3000,	'' ) 
,('2019/10/4',	-4200,	'' ) 
,('2019/10/7',	2000,'') 
,('2019/10/8',	1000,	'') 
,('2019/10/9',	1200,	'') 
,('2019/10/10',	-2600,	'' ) 
,('2019/10/11',	-1800,	'') 
,('2019/10/14',	-3600,	'') 
,('2019/10/15',	-8200,	'') 
,('2019/10/16',	-6200,	'' ) 
,('2019/10/17',	-5000,	'') 
,('2019/10/18',	-3600,	'') 
,('2019/10/21',	2200,	'' ) 
,('2019/10/22',	-3000,	'') 
,('2019/10/23',	-7100,	'') 
,('2019/10/24',	-8200,	'' ) 
,('2019/10/25',	-9600,	'' ) 
,('2019/10/28',	-12000,	'' ) 
,('2019/10/29',	-11000,'') 
,('2019/10/30',	-8000,	'')  
,('2019/10/31',	-3100,	'') 
23 rows affected

select *
from TEST


A
B
C


01/10/2019 00:00:00
-3200


02/10/2019 00:00:00
-3600


03/10/2019 00:00:00
-3000


04/10/2019 00:00:00
-4200


07/10/2019 00:00:00
2000


08/10/2019 00:00:00
1000


09/10/2019 00:00:00
1200


10/10/2019 00:00:00
-2600


11/10/2019 00:00:00
-1800


14/10/2019 00:00:00
-3600


15/10/2019 00:00:00
-8200


16/10/2019 00:00:00
-6200


17/10/2019 00:00:00
-5000


18/10/2019 00:00:00
-3600


21/10/2019 00:00:00
2200


22/10/2019 00:00:00
-3000


23/10/2019 00:00:00
-7100


24/10/2019 00:00:00
-8200


25/10/2019 00:00:00
-9600


28/10/2019 00:00:00
-12000


29/10/2019 00:00:00
-11000


30/10/2019 00:00:00
-8000


31/10/2019 00:00:00
-3100



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) 
8 rows affected

select *
from BASE
where 1=1
order by id


id
M


1
-3000

2
-4000

3
-5000

4
-6000

5
-7000

6
-8000

7
-9000

8
-10000


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


A
B
Email


01/10/2019 00:00:00
-3200
發

02/10/2019 00:00:00
-3600
不發

03/10/2019 00:00:00
-3000
不發

04/10/2019 00:00:00
-4200
發

07/10/2019 00:00:00
2000
不發

08/10/2019 00:00:00
1000
不發

09/10/2019 00:00:00
1200
不發

10/10/2019 00:00:00
-2600
不發

11/10/2019 00:00:00
-1800
不發

14/10/2019 00:00:00
-3600
不發

15/10/2019 00:00:00
-8200
發

16/10/2019 00:00:00
-6200
發

17/10/2019 00:00:00
-5000
不發

18/10/2019 00:00:00
-3600
不發

21/10/2019 00:00:00
2200
不發

22/10/2019 00:00:00
-3000
不發

23/10/2019 00:00:00
-7100
發

24/10/2019 00:00:00
-8200
發

25/10/2019 00:00:00
-9600
發

28/10/2019 00:00:00
-12000
發

29/10/2019 00:00:00
-11000
不發

30/10/2019 00:00:00
-8000
不發

31/10/2019 00:00:00
-3100
不發

A	B	C
01/10/2019 00:00:00	-3200
02/10/2019 00:00:00	-3600
03/10/2019 00:00:00	-3000
04/10/2019 00:00:00	-4200
07/10/2019 00:00:00	2000
08/10/2019 00:00:00	1000
09/10/2019 00:00:00	1200
10/10/2019 00:00:00	-2600
11/10/2019 00:00:00	-1800
14/10/2019 00:00:00	-3600
15/10/2019 00:00:00	-8200
16/10/2019 00:00:00	-6200
17/10/2019 00:00:00	-5000
18/10/2019 00:00:00	-3600
21/10/2019 00:00:00	2200
22/10/2019 00:00:00	-3000
23/10/2019 00:00:00	-7100
24/10/2019 00:00:00	-8200
25/10/2019 00:00:00	-9600
28/10/2019 00:00:00	-12000
29/10/2019 00:00:00	-11000
30/10/2019 00:00:00	-8000
31/10/2019 00:00:00	-3100