так можно выбрать все подчиненные Элементы

DECLARE @level int
CREATE TABLE #stack (ID char(9), level1 int, descr char(180))
/*Insert #Stack select id , 1 , Descr from sc656 where ltrim(ParentId)='0' and IsFolder=1*/
Insert #Stack select id , 1 , Descr from sc656 where ltrim(Code)='42' and IsFolder=1
Select @level = 2
WHILE @level < 10 /*ограничиваю уровень, хотя это и не обязательно*/
BEGIN
Insert #Stack select n.ID, @Level , rtrim(St.Descr)+'\'+RTrim(n.Descr) from sc656 n, #Stack st
where n.parentID In (select s.ID from #stack s) and n.ID Not In (select s.ID from #stack s)
/*and n.IsFolder=1*/ and n.ParentId=st.Id
IF @@ROWCOUNT = 0 break
SELECT @level = @level + 1
END -- WHILE

/*select * from #Stack order by descr*/

select n.descr, /*sp4964 Dat*/ St.Descr from sc656 n,#Stack St where n.Parentid in (select s.id from #Stack s) and n.IsFolder=2
/*and sp4964 > '2001-09-01'*/
order by St.Descr
drop table #Stack