I would like to name my case statement values so I can display it as a column to see what's happening. Here is my code:
left outer join navmenu as nm on navmenu.parentnavmenuid = nm.navmenuid
NavMenu.NavMenuGroupCode IN (2609)
NavMenu.NavMenuName LIKE '%test%'
order by navmenu.navmenugroupcode desc,
case when navmenu.isparentnavmenu = 1 then navmenu.listorder
case when navmenu.isparentnavmenu = 1 then 0
I have another query that uses:
End as 'GlobalOrder'
But when I try something like that with this, it doesn't work.