T-SQL (SS2K8) :: Mapping Hierarchical Relationships

I am trying to build something which allows different user groups to inherit properties from other groups. For instance, a given user group (say 5) would inherit the universe definition of another user group (say 4). The catch is that this might in turn inherit its universe from another user group (say 3, and so on and so forth).

What I want is a way to give the system a user group and return the actual user group from which it inherits.

So extending my previous example above, suppose the following structure of inheritance:

5 <= 4 (5 inherits from 4)
4 <= 3
3 <= 2
2 <= 1
∴ 5 <= 1 (5 inherits from 1)

I feel like there’s a way to do this with an rCTE but the specifics are eluding me. Here’s some sample code

if object_id('tempdb.dbo.#Inherit') is not null drop table #Inherit
create table #Inherit
(
UserGroupId int,
Property varchar(30) check (Property in ('Universe', 'EventInstances', 'Scores')),

[Code] ....