I have Table (ID , Name , ParentID)
ID Name ParentID
1 s null
2 a 1
3 w 2
4 e 2
5 r null
6 l 5
7 b 6
8 k 6
I need Result
ID Name ParentID FullCode
1 s null 01
2 a 1 0101
3 w 2 010101
4 e 2 010102
5 r null 02
6 l 5 0201
7 b 6 020101
8 k 6 020102
I Need Query To Get FullCode