使用T-SQL连接所有父行的字符串的最有效方法是什么？

I have a table that has a self-referencing foreign key that represents its parent row. To illustrate the problem in its simplest form we'll use this table:I have a table that has a self-referencing fore