ms-sql 재귀쿼리
WITH recursive_query(S_MENU_ID,S_U_MENU_ID,S_MENU_NM,sort,dept_S_MENU_NM) AS (SELECTS_MENU_ID, S_U_MENU_ID, S_MENU_NM, convert(varchar(255), S_MENU_ID) sort, convert(varchar(255),S_MENU_NM) dept_S_MENU_NMFROM TBL_MENU_INFOWHERE S_U_MENU_ID IS NULLUNION ALLSELECTb.S_MENU_ID, b.S_U_MENU_ID, b.S_MENU_NM, convert(varchar(255), c.sort + ' > ' + b.S_MENU_ID) sort, convert(varchar(255),c.dept_S_MENU_NM..
더보기