You are a database developer. You plan to create a database by using SQL Server 2008.
The database has a table named Employees. The table contains records of employees and
their managers. The table includes the EmployeelD and ManagerlD fields. The EmployeelD

values are unique. The value in the M anagerlD field is the employee I D of t he e mployee’s
m anager. A Web s ite r equires X ML formatted output of all managers and employees to
be displayed as a tree diagram. You need to produce the required output by querying the
database without using system stored procedures. What should you do?

A.
Create a table-valued function by using the hierarchyid data type.

B.
Create a scalar-valued function by using the FOR XML PATH clause and the TYPE
directive.

C.
Create a scalar-valued function by using the OPENXML () function.

D.
Create a table-valued function by using a common table expression (CTE).