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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-05-19 : 06:33:49
|
| Here i have a table hirarchy as follows T1 | / T2 T3 / /\ T4 T5 T6 T7 / T8 Can we represent the above table dependency as follows?? The columns has to be dynamically added in the output and a astrick symbol has be added/appended depending on level.Meaning depending on the level, that many astricks to be added.I need to supply the Tablename to a stored procedure and should display something as follows *T1 **T2 ***T4 ****T8*T1 **T3 ***T5 NULL*T1 **T3 ***T6 NULL*T1 **T3 ***T7 NULLcan we do like this ???????? |
|
|
Lijo Cheeran Joseph
Posting Yak Master
123 Posts |
Posted - 2010-05-20 : 13:01:34
|
| Hi Could you please let me know what is meant by table hierarchy. Where is this hierarchy information sotred?ThanksLijo |
 |
|
|
|
|
|
hirarchy between tables using sql query