select a.TypeCode,a.TypeName as text,a.TypeID as id ,isnull(b.TypeID,'#')
as parent
from EC_GoodType A
left join EC_GoodType B
on
as parent
from EC_GoodType A
left join EC_GoodType B
on
a.layer=b.layer+1 and CONVERT(BIGINT,A.Path)/10000=CONVERT(BIGINT,B.Path) order by a.typecode
今天这个想要记录的是 CONVERT(BIGINT,A.Path) 例如 A.Path为010000 那么经过convert操作之后,为10000