It won't, Microsoft SQL Server 2005 doesn't support CONNECT BY PRIOR. See recursive common table expression. Supported by Oracle (version dependent) and SQL Server.

Update: See also Simulation of CONNECT BY PRIOR of ORACLE in SQL SERVER