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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-24 : 10:41:45
|
| RAVI writes "IN ORACLE USING THE "CONNECT BY" CLAUSE,WE CAN EASILY CREATE A TREE STRUCTURE LIKE DATA. BUT IN SQL-SERVER SINCE THERE IS NO SUCH WAY AVAILABLE, HOW CAN I CREATE SUCH A TYPE OF DATA. PLEASE ILLUSTRATE BY EXAMPLES(STORED PROCEDURE PREFERABLE)." |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-04-28 : 20:40:07
|
quote:
Said simple Simon to the Pie-man - show me first your whares...
Can you provide us with some example data, or perhaps give us some more detail on what you are trying to do?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-04-29 : 03:53:16
|
Oops typo....whares - wares sold from a wharf? <no maoris were hurt in the making of this post>Edited by - rrb on 04/29/2002 04:00:13 |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-04-29 : 04:30:38
|
quote:
http://www.maori.org.nz/tikanga/whare_f.htm
OK - now I see why you're reading "SQL for Smarties". Are you secretly a Kiwi - or just a keen surfer? (of the web variety)?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2002-04-29 : 05:34:00
|
| Demon Scrabble player. |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-04-29 : 06:01:31
|
| There's no direct equivalent to Oracle's CONNECT BY in SQL Server. But you sure can process hierarchical data using T-SQL. - For starters read the paeg titled "Expanding hierarchies" in SQL Server Books Online. - Go to tsqlsolutions.com and search for hierarchies - Get yourself the book, "Guru's guide to Transact-SQL" which has a chapter on this.--HTH,VyasCheck out my SQL Server site @http://vyaskn.tripod.com |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-04-29 : 18:30:58
|
| Actually, I thought the pie-maori-scrabble discussion was better...Arnold, that explains a lot about your posts.--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
simulating the