가능은 합니다만, 7개의 다른 쿼리라는게 진짜 다른 쿼리인지는 확인해보세요.^^;;

보통 같은 쿼리인데 다른 쿼리라고 생각되는 경우가 많습니다.

select  name as Title, v as value1,v2 as value2 from table_name

union all

select ts as Title, cnt as value1, t_cnt as value2 from table_name 

과 같이 union all 로 쿼리끼리의 결과를 합쳐가져올 수 있습니다.

컬럼이름이 다른건 as 로 이름을 맞춰주시고요. 

MSSQL 공부하고 있는 사람입니다.

공부삼아 만들어봤는데 맞는지 모르겠네요..

틀린부분 있으면 지적 부탁드립니다.

select R.TITLE, R.CODE
  into #tmp
from
(
select 'A' TITLE, '111' AS CODE UNION ALL
select 'A' TITLE, '222' AS CODE UNION ALL
select 'A' TITLE, '333' AS CODE UNION ALL
select 'A' TITLE, '444' AS CODE UNION ALL
select 'A' TITLE, '555' AS CODE UNION ALL
select 'A' TITLE, '666' AS CODE UNION ALL
select 'B' TITLE, '111' AS CODE UNION ALL
select 'B' TITLE, '222' AS CODE UNION ALL
select 'B' TITLE, '333' AS CODE UNION ALL
select 'B' TITLE, '666' AS CODE UNION ALL
select 'C' TITLE, '222' AS CODE UNION ALL
select 'C' TITLE, '333' AS CODE UNION ALL
select 'C' TITLE, '555' AS CODE
) R

select x.title
  , MAX(value1) value1
  , MAX(value2) value2
  , MAX(value3) value3
  , MAX(value4) value4
  , MAX(value5) value5
  , MAX(value6) value6
  , MAX(value7) value7
  from(
  select a.title
   , (CASE WHEN a.seq = 1 then a.code else '' end) value1
   , (CASE WHEN a.seq = 2 then a.code else '' end) value2
   , (CASE WHEN a.seq = 3 then a.code else '' end) value3
   , (CASE WHEN a.seq = 4 then a.code else '' end) value4
   , (CASE WHEN a.seq = 5 then a.code else '' end) value5
   , (CASE WHEN a.seq = 6 then a.code else '' end) value6
   , (CASE WHEN a.seq = 7 then a.code else '' end) value7
    from(
    select title
      , code
      , row_number() over(partition by title order by title)  as seq
      from #tmp
      ) A
    ) X
 group by x.title