Re: Hierarchical query

I agree that the problem can be solved without using an extra column, but what I was referring to was that it wasn't good database design. If the table you're using will be static then the above procedure will work properly, but there will be problems if your table is a dynamic table. Let's say you want to insert another branch under Salary. This will mean having to change all the numbers for each insert.

Thanks,
Kirtan Received on Tue Mar 22 2005 - 21:34:15 CST