SELECT a, b, c FROM (
VALUES
('C', 1, 'H' ) ,
('C', 2, 'I' ),
('C', 3, 'H' ),
('B', 2, 'H' ),
('B', 3, 'H' ),
('B', 2, 'I' ),
('C', 3, 'H' ),
('A', 3, 'I' )) AS Tb(a, b,c);


우아... 쥑인답!!!

쿼리 테스트 할때 구지... 어렵게 할필요가 없네???

또는 Union All 걸어가면서 만들었던것도... 이제 바이 바이.. ~

 EX )

SELECT NM, SUM( SM ) SM, ISNULL( MAX(H)+'/', '' ) + ISNULL( MAX(I) , '' ) HI
FROM
(
 SELECT NM, SUM( SMALL ) SM , case KIND when 'H' then 'H' end  H, case KIND when 'I' then 'I' end  I
 FROM
 (
  SELECT NM, SMALL, KIND
  FROM (VALUES
  ('C', 1, 'H' ) ,
  ('C', 2, 'I' ),
  ('C', 3, 'H' ),
  ('B', 2, 'H' ),
  ('B', 3, 'H' ),
  ('B', 2, 'I' ),
  ('C', 3, 'H' ),
  ('A', 3, 'I' )) AS Tb( NM, SMALL, KIND )
 ) O
 GROUP BY NM, KIND
) M
GROUP BY NM