Recursive Query Help

Posted by Josh on Stack Overflow See other posts from Stack Overflow or by Josh
Published on 2010-03-29T16:11:40Z Indexed on 2010/03/29 16:33 UTC
Read the original article Hit count: 430

I have two tables in my database schema that represent an entity having a many-to-many relationship with itself.

Role  
---------------------
+RoleID 
+Name

RoleHasChildRole
---------------------
+ParentRoleID  
+ChildRoleID  

Essentially, I need to to be able to write a query such that:

Given a set of roles, return the unique set of all related roles recursively.

This is an MSSQL 2008 Database.

© Stack Overflow or respective owner

Related posts about sql-server-2008

Related posts about sql