Is it any functions similar to "START WITH" and "CONNECT BY" in MS

Hi all,
I am looking for some functions which are used as "Start with" and "Connect
By" in Oracle. Please help! Thx a lot.
Regards,
ThomasHello, Thomas
If you are interested in recursive queries for processing a tree-like
data structure, you should take a look at CTE-s (Common Table
Expressions) and Recursive CTE-s in Books Online and other MSDN
articles:
http://msdn2.microsoft.com/en-us/library/ms175972.aspx
http://msdn.microsoft.com/msdnmag/i...TSQLinYukon/#S7
Razvan|||Hi,
There is no equivalent of start with and connect by of oracle in sql
server,
got thorugh this links,
credit - vyaskn
s.htm" target="_blank">http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
Handling hierarchical data in Sql Server =>
http://vyaskn.tripod.com/hierarchie...r_databases.htm
Thanks,
Sree
Razvan Socol wrote:
> Hello, Thomas
> If you are interested in recursive queries for processing a tree-like
> data structure, you should take a look at CTE-s (Common Table
> Expressions) and Recursive CTE-s in Books Online and other MSDN
> articles:
> http://msdn2.microsoft.com/en-us/library/ms175972.aspx
> http://msdn.microsoft.com/msdnmag/i...TSQLinYukon/#S7
> Razvan|||> There is no equivalent of start with and connect by of oracle in sql
> server,
> got thorugh this links,
This information has not been updated for SQL 2005. Did you not follow the
links Razvan posted? It is certainly possible to accomplish this using
CTEs.
Hope this helps.
Dan Guzman
SQL Server MVP
<gsreejith@.gmail.com> wrote in message
news:1138965840.226876.87400@.g49g2000cwa.googlegroups.com...
> Hi,
> There is no equivalent of start with and connect by of oracle in sql
> server,
> got thorugh this links,
> credit - vyaskn
> s.htm" target="_blank">http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
> Handling hierarchical data in Sql Server =>
> http://vyaskn.tripod.com/hierarchie...r_databases.htm
> Thanks,
> Sree
>
> Razvan Socol wrote:
>|||So, Should explicitly say for Sql Server 2000...
I have not tried CTE yet
Anyway thanks for correcting.
Thanks,
Sree