Код

Select
*
From
(SELECT
  Спр.IsFolder
, Спр.CODE
, CASE WHEN RTrim(LTrim(Спр4.Code)) <> ''  THEN RTrim(LTrim(Спр4.Code))+'/' ELSE '' END +
CASE WHEN RTrim(LTrim(Спр3.Code)) <> ''  THEN RTrim(LTrim(Спр3.Code))+'/' ELSE '' END +
CASE WHEN RTrim(LTrim(Спр2.Code)) <> ''  THEN RTrim(LTrim(Спр2.Code))+'/' ELSE '' END +
CASE WHEN RTrim(LTrim(Спр1.Code)) <> ''  THEN RTrim(LTrim(Спр1.Code))+'/' ELSE '' END + RTrim(LTrim(Спр.Code)) ПолнКод
, CASE WHEN RTrim(LTrim(Спр4.Code)) <> ''  THEN 1 ELSE 0 END +
  CASE WHEN RTrim(LTrim(Спр3.Code)) <> ''  THEN 1 ELSE 0 END +
  CASE WHEN RTrim(LTrim(Спр2.Code)) <> ''  THEN 1 ELSE 0 END +
  CASE WHEN RTrim(LTrim(Спр1.Code)) <> ''  THEN 1 ELSE 0 END + 1 Уровень
, Спр.DESCR
FROM
  $Справочник.Номенклатура as Спр (NoLock )
  Left Join $Справочник.Номенклатура as Спр1 (NoLock ) on Спр1.ID = Спр.ParentID  AND Спр1.IsFolder = 1
  Left Join $Справочник.Номенклатура as Спр2 (NoLock ) on Спр2.ID = Спр1.ParentID AND Спр2.IsFolder = 1
  Left Join $Справочник.Номенклатура as Спр3 (NoLock ) on Спр3.ID = Спр2.ParentID AND Спр3.IsFolder = 1
  Left Join $Справочник.Номенклатура as Спр4 (NoLock ) on Спр4.ID = Спр3.ParentID AND Спр4.IsFolder = 1
) as Temp1
ORDER BY Temp1.ПолнКод, Temp1.Isfolder, Temp1.DESCR