Wednesday, December 23, 2015

Disply category and sub category

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

No comments:

Post a Comment