Attaching a column for the case statement results in sql query
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:
I have another query that uses:
But when I try something like that with this, it doesn't work.
Help?
thanks!
SELECT NavMenu.*
from NavMenu
left outer join navmenu as nm on navmenu.parentnavmenuid = nm.navmenuid
WHERE
NavMenu.NavMenuGroupCode IN (2609)
AND
NavMenu.NavMenuName LIKE '%test%'
order by navmenu.navmenugroupcode desc,
case when navmenu.isparentnavmenu = 1 then navmenu.listorder
Else nm.listorder
END ASC,
case when navmenu.isparentnavmenu = 1 then 0
else 1
END ASC,
NavMenu.ListOrder
I have another query that uses:
End as 'GlobalOrder'
But when I try something like that with this, it doesn't work.
Help?
thanks!
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Also I don't see 'GlobalOrder' in your posted solution, so hard to see how that worked for you.
Also as long as the name does not include spaces or punctuation marks other than underscore, the single quotes ' ' are not needed.