Skip to Content
0
Former Member
Nov 23, 2010 at 04:57 AM

Hierarchy Numbering

299 Views

How will we number the parentid,childid and nextid levels of a hierarchy.I want a step by step solution.

For Eg

NODEID INFOOBJECT NODENAME LINK PARENTID CHILDID NEXTID DATETO DATEFROM LANGU TXTSH TXTMD TXTLG

1 0HIER_NODE WORLD 0 2 0 20091231 20090101 D WORLD

2 0HIER_NODE ASIA 1 3 10 20091231 20090101 D ASIA

3 0HIER_NODE INDIA 2 4 6 20091231 20090101 D INDIA

4 0PLANT 1234 3 0 5 20091231 20090101 D

5 0PLANT 1235 3 0 0 20091231 20090101 D

6 0HIER_NODE CHINA 2 7 0 20091231 20090101 D CHINA

7 0PLANT 2393 6 0 8 20091231 20090101 D

8 0PLANT 2394 6 0 9 20091231 20090101 D

9 0PLANT 2395 6 0 0 20091231 20090101 D

World

Asia

India

1234

1235

China

2393

2394

2395