SELECT TOP (100) PERCENT catName, ID, ParentMenuId, LinkPage
FROM (SELECT ISNULL(C.Name + '>', '') + ISNULL(B.Name + '>', '') + A.Name AS catName, A.ID, A.ParentMenuId, A.Name AS LinkPage
FROM dbo.ISMenu AS A LEFT OUTER JOIN
dbo.ISMenu AS B ON A.ParentMenuId = B.ID LEFT OUTER JOIN
dbo.ISMenu AS C ON B.ParentMenuId = C.ID) AS P
FROM (SELECT ISNULL(C.Name + '>', '') + ISNULL(B.Name + '>', '') + A.Name AS catName, A.ID, A.ParentMenuId, A.Name AS LinkPage
FROM dbo.ISMenu AS A LEFT OUTER JOIN
dbo.ISMenu AS B ON A.ParentMenuId = B.ID LEFT OUTER JOIN
dbo.ISMenu AS C ON B.ParentMenuId = C.ID) AS P