Desenvolver um Software

I need queries sql server for reports like balance sheet. It is not necessary to have sums of values​​, but it takes hierarchy in the register of accounts. For example the attached sheet with two reports must be in the system. And the structure database below: Financial Tables: Account IdAccount int IdCompany int CodEstruturador int OrdemRel int DescrConta nchar(40) ItemDeducao bit HierarqConta hierarchyid TiposRel CodRel int DescrRel int Estruturadores CodEstruturador int IdCompany int CodRel int DescrEstruturador int HierarqEstruturador hierarchyid (report hierarchy) OrdemRel int MVContasEstruradores IdCompany int IdAccount int CodEstruturador int DescrGrp nchar(40) PeriodosBase CodPeriodoBase int CodTpPeriodoBase int OrdemRel int DescrPeriodoBase nchar(15) TiposPeriodosBase (like a years or month columns) CodTpPeriodoBase int DescrTp int (mensal, anual) MVAccount CodLanc int IdCompany int IdAccount int CodPeriodoBase int Obs nchar(30) CodPeriodoBase int RefPeriodoBase int (year or month like 2014 or JAN til DEC) Valor decimal(18,2) LancAutomático bit UserID int DtLanc datetime Need this job as soon as possible.