find total money of parent node of mlm tree according to a particular pattern in mlm project using SQL Query

Label the tree nodes like in the following orgchart:

http://www.sqlusa.com/bestpractices2005/organizationtree/

Likely counting will be easy with labelled nodes.

---

Kalman Toth Database & OLAP Architect IPAD SELECT Query Video Tutorial 3.5 Hours

New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012