개발 관련

※ 이 내용은 MS-SQL 2008 버전 이상에서 사용이 가능하다. 1. 데이터 유형 hierarchyid 를 이용한  계층구조 테이블 생성CREATE TABLE TBB_CODE( OrgNode hierarchyid PRIMARY KEY CLUSTERED, OrgLevel AS OrgNode.GetLevel(), [BASE_CD] [varchar](50) NOT NULL, [CD_GRP] [varchar](50) NULL, [CD_NAME] [varchar](255) NULL, [CD_ENAME] [varchar](255) NULL, [DVALUE] [decimal](38, 10) NULL, [SVALUE] [varchar](255) NULL, [DESC] [varchar](1024) NULL, [ORD..

/****** Object:  StoredProcedure [dbo].[SPP_ResultTailInfo_Tree]    Script Date: 2016-07-01 오전 10:27:21 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author:  jwcho-- Create date: 2016.06.22-- Modify date: 2016.07.01-- =============================================ALTER PROCEDURE [dbo].[SPP_ResultTailInfo_Tree] @V_PRJ_ID VARCHAR(50)=NULL,  ..

with recursive CTE     --(PATH_, Level, PRJ_ID, ID, HR_ID, NAME) as (   select CAST(NAME AS VARCHAR(3000)) AS PATH_, 1 as Level, PRJ_ID, ID, HR_ID, NAME   from CteTable    where PRJ_ID = 'A1607001'     --and ID = 'C00002'    and NAME = '연습'   union all   select cast((t.PATH_ || '/' || e.NAME) as VARCHAR(3000)) as PATH_,(t.Level + 1) as Level, e.PRJ_ID, e.ID, e.HR_ID, e.NAME   from CteTable e joi..