Connect by in SQL Server

[qhjghz]

Hi,
Actually I have been working in Oracle for some time and have been very fond of the CONNECT BY, SYS_CONNECT_BY_ PATH clauses :)
Are there any such hierarchical functions in SQL Server 2005?

[debasisdas]

Please find about hierarchical queries in SQL SERVER here.