Recursive sql with parent child relationship in sql server.

If i have a table name Document and its fields are ID, Name and ParentID

than my sql query will look like

WITH Temp_Doc(ID,ParentID,Name,itteration) AS
(
SELECT ID,ParentID,Name,0 FROM Document WHERE ID = 570
UNION ALL SELECT b.ID, b.ParentID, b.Name, itteration +1
FROM Temp_Doc AS a, Document AS b
WHERE a.ID = b.ParentID
)
SELECT * FROM Temp_Doc OPTION (MAXRECURSION 500);