SELECT CODE, NAME, NULL,
MAX(CASE WHEN [E01] > [E02] THEN '02'
WHEN [E01] < [E02] THEN '01'
ELSE '99' END),
MAX(CASE WHEN [D01] > [D02] AND [D01] > [D03] AND [D01] > [D04] AND [D01] > [D05] AND [D01] > [D06] THEN '01'
WHEN [D02] > [D03] AND [D02] > [D04] AND [D02] > [D05] AND [D02] > [D06] THEN '02'
WHEN [D03] > [D04] AND [D03] > [D05] AND [D03] > [D06] THEN '03'
WHEN [D04] > [D05] AND [D04] > [D06] THEN '04'
WHEN [D05] > [D06] THEN '05'
ELSE '06' END) , 'N', '','','import', getdate(), 'import', getdate()
FROM [MetaSyn].[dbo].[40Fdata]
GROUP BY CODE, NAME
HAVING NAME IS NOT NULL
MS-SQL 자체 암호화 처리 방법 (0) | 2015.01.15 |
---|---|
Column List (0) | 2014.12.01 |
RPAD 구현 (0) | 2014.09.18 |
varchar 와 nvarchar (0) | 2014.07.16 |
테이블 별 사용량 확인 (0) | 2014.07.16 |