posted 15 years ago
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.