;WITH tree (ID, childID) AS
(SELECT ID, childID FROM @t2 WHERE ID= 1 
UNION ALL SELECT V.ID, V.childID FROM @t2 V INNER JOIN tree t ON t.childID = V.ID) 
SELECT * FROM tree

Error: near "WITH": syntax error