I had a similar problem like you,

Heres my solution to it. Would welcome expert opinions, if its acceptable.

My table consists of 4 columns

ParentId,NodeId(this is the child node), LevelId, TreeStructure(i just...