SQL Server Performance

multiple self join

Discussion in 'General Developer Questions' started by Nadeem, Mar 24, 2011.

  1. Nadeem New Member

    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
  2. FrankKalis Moderator

Share This Page