This will probably help you out and it details how to get the hierarchy out of the AdventureWorks database for Manger vs Employee

http://technet.microsoft.com/en-us/library/ms186243(v=sql.105).aspx