세로를 가로로 출력하기
SELECT AA.ACCTUNIT_CD, AA.ACCT_CTG_CD ,
ISNULL(MAX(Case ROWNUMBER When 1 Then AA.MNG_ITEM_CD end),'') MNG_ITEM_CD_1,
ISNULL(MAX(Case ROWNUMBER When 2 Then AA.MNG_ITEM_CD end),'') MNG_ITEM_CD_2,
ISNULL(MAX(Case ROWNUMBER When 3 Then AA.MNG_ITEM_CD end),'') MNG_ITEM_CD_3,
ISNULL(MAX(Case ROWNUMBER When 4 Then AA.MNG_ITEM_CD end),'') MNG_ITEM_CD_4,
ISNULL(MAX(Case ROWNUMBER When 5 Then AA.MNG_ITEM_CD end),'') MNG_ITEM_CD_5
FROM (
select
ROW_NUMBER() OVER(PARTITION BY A.ACCTUNIT_CD, A.ACCT_CTG_CD ORDER BY A.ACCTUNIT_CD ASC,A.ACCT_CTG_CD ASC, B.MNG_ITEM_CD ASC) AS ROWNUMBER
, A.ACCTUNIT_CD
, A.ACCT_CTG_CD
, B.MNG_ITEM_CD
,B.MNG_ITEM_NM
from TB_FA_ACCT_MNG_ITEM A
INNER JOIN TB_FA_MNG_ITEM B
ON A.ACCTUNIT_CD = B.ACCTUNIT_CD
AND A.MNG_ITEM_CD = B.MNG_ITEM_CD
) AA
GROUP BY AA.ACCTUNIT_CD, AA.ACCT_CTG_CD