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 |
|
sean khan
Starting Member
4 Posts |
 Posted - 2001-02-12 : 09:35:44
|
| I have a data model consisting of 2 tables: AdrTbl and RelTblAdrTbl has the following:adr_idadr_namerelTbl has the following: adr_parent_idadr_idEach entry in AdrTbl is described in relTbl as parent/child.I want to produce a hierachical listing of parents/children/grandchildren etc.I can get a list from a series of join and alias statments then use VBscript to sort it out. I uderstand that using SHAPE techniques makes it much easier. Does anyone know how to apply this for the case where an address can be a "division", "branch", "unit" or employee ? |
|
|
|
|
|
using SHAPE APPEND, RELATE