create view vwPageHierachy
as 
select distinct b.AutoID, SPACE(b.PageLevel) + b.PageDescription as PageDescription, b.PageLevel, b.PageOrder, b.Hier
, case b.PageLevel
	when 1 then 0
	else 1s
end as HasParent
, SUBSTRING(SUBSTRING(Hier, 0, Len(Hier)-CHARINDEX(',', reverse(Hier))+1), 
	CHARINDEX(',', reverse(SUBSTRING(Hier, 0, Len(Hier)-CHARINDEX(',', reverse(Hier))+1)))+1, 
	LEN(SUBSTRING(Hier, 0, Len(Hier)-CHARINDEX(',', reverse(Hier))+1)) - CHARINDEX(',', reverse(SUBSTRING(Hier, 0, Len(Hier)-CHARINDEX(',', reverse(Hier))+1)))
	) as ParentID
from tblPageHierachyOrg b




create view vwParentCategory

as