Hello,

can you check using the below query

if the query is not okay,can you explain a bit about Order Column

with cte as

(select MenuID,MenuDesc,ParentMenu

,Sequence,1 as Lev

from Menus

where ParentMenu is null

UNION ALL

select m.MenuID,m.MenuDesc,m.ParentMenu

,m.Sequence,Lev+1

from cte

join Menus m

on m.ParentMenu=cte.MenuID

)select MenuID,MenuDesc,ParentMenu,Sequence,ROW_NUMBER()over(order by MenuID) as [Order]

,Lev

from cte