请教一个sql语句,关于递归查询

Question

CREATE TABLE [dbo].DTB NULL,
[FNAME] nchar(50) NULL,
[TID] char(10) NULL,
[TNAME] nchar(50) NULL)
ON [PRIMARY]
WITH (DATA_COMPRESSION = NONE);

insert into DTB values (-1,'Start',7,'ST')
insert into DTB values (-1,'Start',8,'BM')
insert into DTB values (7,'ST',-14,'CK')
insert into DTB values (8,'BM',-10,'CK')
insert into DTB values (-14,'CK',4,'CT')
insert into DTB values (-10,'CK',4,'CT')
insert into DTB values (4,'CT',-11,'CK')
insert into DTB values (-11,'CK',164,'BCT')
insert into DTB values (-14,'CK',-13,'RP')
insert into DTB values (-13,'RP',7,'ST')
insert into DTB values (-10,'CK',-13,'RP')
insert into DTB values (-13,'RP',8,'BM')
insert into DTB values (-11,'CK',-13,'RP')
insert into DTB values (-13,'RP',4,'CT')
insert into DTB values (164,'BCT',-16,'End')

能够按照红线和蓝线将流程解析出来，我采用CTE进行解析的时候，发现不能达到我的期望值，请高手指点。