I need multiple level in one table for chart of account. let me explain it. I have enter all levels in one table. For it i devide code in multiple parts 0 00 00 000 First 0 is first level second level have two digit third level is two digit as well and fourth level is three digit 1 00 00 000 Assets 1 10 00 000 Fixed Assets 1 10 10 000 Buildings 1 10 10 101 abc building 1 10 10 102 xyz building 1 10 20 000 Vehicle 1 10 20 101 abc Vehicle 1 10 20 102 xyz Vehicle 2 00 00 000 Expense etc now i need to first second and third level at fourth level mean if i m at abc vehicle i need to know its third second and first level more over actually i need level wise total in crystal report for vb.net using with sql server 2000 how i can achieve it, welcome any suggestion thanks in advance
For SQL Server 2000 this is possibly a good page to look at: http://www.sqlteam.com/article/more-trees-hierarchies-in-sql