title: T-SQL CTE count ALL Leaves beneath a node
body: <p>All CTE examples that I can find with respect to counting involve the classic 'how many direct reports' does a manager have.
  I have a subtle take on that which I cant figure out.
  Essenitally I want to see for each node in a hierarchy, how many others in TOTAL are beneath at ALL levels.
  So if I had 12 people in a company, the chap at the top has 11 beneath him,
  He may have 3 direct reports, the first may have 2, the second 4 and the third 3
  etc etc.
  I just can't figure out how to get the sum of all beneath a node, please help!</p>