CREATE TABLE XSTAT (

 XDAY VARCHAR(8),

 BCODE varchar(3),

 BNAME varchar(20),

 NCOUNT int,

 OCOUNT int,

 PCOUNT int

)

insert into XSTAT VALUES( '20071220', '001','A부서',5,2,1)

insert into XSTAT VALUES( '20071220', '002','B부서',3,0,0)

insert into XSTAT VALUES( '20071220', '003','C부서',2,1,0)

----------------------------------------------------------------

SELECT MAX(CASE BCODE WHEN '001' THEN S END),

       MAX(CASE BCODE WHEN '002' THEN S END),

       MAX(CASE BCODE WHEN '003' THEN S END)

  FROM (SELECT A.BCODE,B.COLID,

               CASE B.NAME WHEN 'XDAY' THEN CONVERT(VARCHAR,A.XDAY)

                           WHEN 'BCODE' THEN CONVERT(VARCHAR,A.BCODE)

                           WHEN 'BNAME' THEN CONVERT(VARCHAR,A.BNAME)

                           WHEN 'NCOUNT' THEN CONVERT(VARCHAR,A.NCOUNT)

                           WHEN 'OCOUNT' THEN CONVERT(VARCHAR,A.OCOUNT)

                           WHEN 'PCOUNT' THEN CONVERT(VARCHAR,A.PCOUNT) END S                           

         FROM XSTAT A CROSS JOIN SYSCOLUMNS B

        WHERE B.ID = OBJECT_ID('XSTAT')) T

 GROUP BY COLID

/*

------------------------------ ------------------------------ ------------------------------

20071220                       20071220                       20071220

001                            002                            003

A부서                           B부서                           C부서

5                              3                              2

2                              0                              1

1                              0                              0

경고: 집계 또는 다른 SET 연산에 의해 Null 값이 제거 되었습니다.

(6개 행 적용됨)

*/