Sean Lange (4/29/2011)

---

The following code would get the entire hierarchy but I am not sure this is what you want.

declare @EmpID char(10)

set @EmpID = 'Rs001'

;with cte as (

select EmpID,...

WayneS (4/29/2011)

---

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the...