Query Cascade records from sql server

See more:

SQL-Server

recursion

Hi Friends,

Am using MSSQL Server,
In TableA, there are three fields(Userid,Username,ManagerId).

SQL

Userid  - Username - ManagerId
32    -    A    -     13
33    -    B     -    32
132    -   C     -    45
211    -   D     -    32
23     -   E     -    76
260     -  F     -    33
206    -   G     -    33
208   -    H     -    211

Now I want to query from TableA like
If UserId 32 logsin, I want to take userid(33,211) having mangaer id as 32, then to take userid(260,206,208)having managerid as 33 and 211 and so on....

Regards,
RK