Counting rows in a subtree

(Rudy Limeback) There is a table called User (userID PK, userName, supUserID FK). SupUserID refers to userID and contains the userID value of the user’s superior. The highest user has no user superior to itself (NULL instead of a value) and can have under itself one or more users or no users at all.

Read More - Register for Free Membership