帐户层次结构Salesforce帐户 - SQL Server

I am working on a report that uses Salesforce Datawarehouse. Essentially, given a particular account, I need to find the hierarchy just for that. This could be at any level down but it HAS to get ALL the NODES. I am working on a report that uses Salesforce D