I did develop a  recursive stored procedure but when i try to include the child count , i am losing the efficiency of the SP is gone.

Here is the store...