SQL Server 2017

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

CREATE TABLE Temp
(year_3 int, mon int,dep nvarchar(10),income int,
t1 nvarchar(20),t2 nvarchar(20),t3 nvarchar(20));
INSERT INTO Temp 
SELECT year_3 = 108,mon = 1 ,
dep = N'A',income = 100,t1 = N'F',t2 = N'F',t3 = N'T'
1 rows affected

INSERT INTO Temp 
SELECT year_3 = 108,mon = 1 ,
dep = N'A',income = 200,t1 = N'T',t2 = N'F',t3 = N'F'
1 rows affected

INSERT INTO Temp 
SELECT year_3 = 108,mon = 1 ,
dep = N'B',income = 300,t1 = N'T',t2 = N'F',t3 = N'F'
1 rows affected

INSERT INTO Temp 
SELECT year_3 = 108,mon = 1 ,
dep = N'B',income = 400,t1 = N'F',t2 = N'T',t3 = N'F'
1 rows affected

INSERT INTO Temp 
SELECT year_3 = 108,mon = 1 ,
dep = N'C',income = 500,t1 = N'T',t2 = N'F',t3 = N'F'
1 rows affected

select *
from Temp;


year_3
mon
dep
income
t1
t2
t3


108
1
A
100
F
F
T

108
1
A
200
T
F
F

108
1
B
300
T
F
F

108
1
B
400
F
T
F

108
1
C
500
T
F
F


SELECT year_3,mon,dep,income,
(CASE
WHEN t1='T' THEN N'已收'
WHEN t2='T' THEN N'未收'
WHEN t3='T' THEN N'取消'
END) AS '狀態'
FROM Temp


year_3
mon
dep
income
狀態


108
1
A
100
取消

108
1
A
200
已收

108
1
B
300
已收

108
1
B
400
未收

108
1
C
500
已收

year_3	mon	dep	income	狀態
108	1	A	100	取消
108	1	A	200	已收
108	1	B	300	已收
108	1	B	400	未收
108	1	C	500	已收