Here is my stored procedure code:

WITH EmployeeCTE

AS

(

SELECT

UID, firstname, lastname,

1 AS Level,

CONVERT(VARBINARY(MAX), UID) AS thePath

FROM tblUsers

WHERE MID = 604

UNION ALL

...