How to implement a hierarchical query?

Question

SQL Server

Here is the text of the task

13.3 Write a procedure that displays all subordinates of a given salesperson, both immediate and subordinate subordinates. The function uses EmployeeID as the input parameter. As an algorithm for solving this problem, you should use the example given in Books Online and recommended by Microsoft for solving this type of problem.

I can't find this example, I only found examples with the hierarcyid type. But there are no such fields in this table. There are EmployeeID and ReportsTo fields which are the keys. Prompt beautiful implementation. Or at least working. Thank you.

Answer 1

Recursive cte www.sql-tutorial.ru/ru/book_recursive_cte.html