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.
| Author |
Topic |
|
bobanjayan
Yak Posting Veteran
67 Posts |
 Posted - 2004-07-23 : 06:34:44
|
| Hi,select lpad(' ',2*(level-1)) || to_char(child) s from test_connect_by start with parent is null connect by prior child = parent;This is an example of query used in Oracle for Heirarchical results.Is there any thing like this in SQL Server?It is little urgent...Please.. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
Query for Heirarchical results....