Example Connect by prior, pleasee

helllo
what is the intruction that execute "connect by prior" en sql serverThat is Oracle's proprietary syntax. Check out (in 2005) "common table expression", using the WITH
keyword. It allow you to traverse a hierarchy.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jesus Suarez" <suarez.lopezjesus@.gmail.com> wrote in message
news:OUWRGe8aHHA.2088@.TK2MSFTNGP05.phx.gbl...
> helllo
> what is the intruction that execute "connect by prior" en sql server
>