Build Hierarchial tree of companies

gistfile1.sql

WITH 
  under_comp(id, alias, level, sort) AS (
    select id, alias, 0 as level, cast(alias as varchar(max)) from cdmcomp where id = '16281-----SPPL-SPPL'
    UNION ALL
    SELECT cdmcomp.id, cdmcomp.alias, under_comp.level+1, sort + ':' + cdmcomp.alias
      FROM cdmcomp JOIN under_comp ON cdmcomp.primComp=under_comp.id

  )
SELECT
	id, 
	SUBSTRING ('..........',1,level*3) + alias 
FROM under_comp order by sort