Given a recursive query that starts with a child, how can I eliminate sibling and parent rows?, Sql Server

Given a recursive query that starts with a child, how can I eliminate ...

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 4, rows affected: 7, absolute service time: 0,17 sec

latest | history

  
ProjectId
ProjectName
ParentId

1
3
Test Project 2 Sub Project 1
2

2
4
Test Project 2 Sub Project 2
2

3
6
Test Project 2 Sub Sub Project 1
3

4
7
Test Project 2 Sub Sub Sub Project 1
6

λ

                                      .NET NoSQL database for rapid development