• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Hierarchy Generation

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

I need to generate a hierarchy in the below format for large amount of Id's :

Id |Level Id| HierarchyId
123 -1==>123
124 -2==>123.124
125 -3 ==>123.124.125
126 -4 ==>123.124.125.126
127 -5 ==>123.124.125.126.127
128 -6 ==>123.124.125.126.127.128
129 -7 ==>123.124.125.126.127.128.129
130 -5 ==>123.124.125.126.130
131 -6 ==>123.124.125.126.130.131
132 -7 ==>123.124.125.126.130.131.132
133 -4 ==>123.124.125.133
134 -5 ==>123.124.125.133.134
135 -6 ==>123.124.125.133.134.135
.
.
.
.
.
The ID| LevelId|HierarchyId format is as above.I tried using a List collection.working fine
Any better way to do this???

any suggestions ...


Thanks,
naresh.
reply
    Bookmark Topic Watch Topic
  • New Topic