如何在SQL Server中获取分层CTE以使用父子逻辑进行过滤

I'm having a vexing problem with a hierarchical CTE and some strange logic that we need to address that I really hope someone could assist with pointing out what I'm doing wrong to address this scenario with a CTE.I'm having a vexing problem with a hierarchical