Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Connect by in SQL SERVER ?

Author  Topic 

user9999
Starting Member

2 Posts

Posted - 2010-09-03 : 16:20:14
Hello Gurus,

I m totally new T- SQL. I was wondering similar to oracle PL/SQL Connect BY function, do we anything similar in TSQL ?

Or do you know any TSQL Hirarchial functions helps in building hirarchial queries ?

Thank you so much!!

Appriciate It!!

Vinnie881
Master Smack Fu Yak Hacker

1231 Posts

Posted - 2010-09-03 : 22:30:41
I am not familiar with CONNECT BY, please explain what you are trying to accomplish.


Success is 10% Intelligence, 70% Determination, and 22% Stupidity.
\_/ _/ _/\_/ _/\_/ _/ _/- 881
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-09-06 : 05:07:26
Read about Common Table Expression in SQL Server help file

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -