Connect By SQL

Hi all,
Does SQL Server 2000 have something similar to START WITH and CONNECT BY
like Oracle?
Thanks,
Ivan
Hi,
It is not in sql server 2000. But it is introduced in SQL 2005.
Thanks
Hari
SQL Server MVP
"Ivan Debono" <ivanmdeb@.hotmail.com> wrote in message
news:OkZYdd7WFHA.3716@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> Does SQL Server 2000 have something similar to START WITH and CONNECT BY
> like Oracle?
> Thanks,
> Ivan
>

Connect By SQL

Hi all,
Does SQL Server 2000 have something similar to START WITH and CONNECT BY
like Oracle?
Thanks,
IvanHi,
It is not in sql server 2000. But it is introduced in SQL 2005.
Thanks
Hari
SQL Server MVP
"Ivan Debono" <ivanmdeb@.hotmail.com> wrote in message
news:OkZYdd7WFHA.3716@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> Does SQL Server 2000 have something similar to START WITH and CONNECT BY
> like Oracle?
> Thanks,
> Ivan
>