"Kiran" <anonymous@discussions.microsoft.com> wrote in message
news:12c201c47b80$08c4c4c0$a601280a@phx.gbl...
>
> Hi,
> Actually i have one emp table with Columns [id,
> name, salary, DOB, mgrid]. I want to display employee
> data in tree structure, in relation with their
> supervisors [Managers] (like explaned below) from emp
> table.
> This tree can go to any range. Can any body help
> to write the t-sql query for this.
>
>
> A - Name
> AA - Name
> AB - Name
> ABA - Name
> AC - Name
> ACA - Name
>
>
> Thx
> Kiran