[MS-SQL] Tree Menu
2018.08.14 | DevDream
WITH TREE_MENU AS (
SELECT
MENU_ID
, PARENT_ID
, MENU_NAME
, DEPTH
, SORT
, CONVERT(VARCHAR(100), MENU_ID) GROUP_ID
, CONVERT(VARCHAR(100), MENU_NAME) TREE_MENU_NAME
FROM MENU
WHERE PARENT_ID = ''
UNION ALL
SELECT
...