例如现在是:
HEADER1 HEADER2 HEADER3
-----------------------------
AAA1 BBB1 CCC1
AAA2 BBB1 CCC2
AAA3 BBB2 CCC3我想调整成这样的格式:HEADER1 HEADER3
-----------------------------
BBB1
---------------------
AAA1 CCC1
AAA2 CCC2
---------------------
BBB2
---------------------
AAA3 CCC3
......请问如何做呢?谢谢
HEADER1 HEADER2 HEADER3
-----------------------------
AAA1 BBB1 CCC1
AAA2 BBB1 CCC2
AAA3 BBB2 CCC3我想调整成这样的格式:HEADER1 HEADER3
-----------------------------
BBB1
---------------------
AAA1 CCC1
AAA2 CCC2
---------------------
BBB2
---------------------
AAA3 CCC3
......请问如何做呢?谢谢
create table test
(
ID int identity(1,1),
HEADER1 varchar(50),
HEADER2 varchar(50),
HEADER3 varchar(50),
tempId int default(0)
)insert into test(HEADER1, HEADER2, HEADER3)
select 'AAA1', 'BBB1', 'CCC1' union all
select 'AAA2', 'BBB1', 'CCC2' union all
select 'AAA3', 'BBB2', 'CCC3' insert into test(HEADER1, HEADER2, HEADER3, tempid)
select '', HEADER2, '', 1
from test
where id
in
(
select min(id) as min from test group by HEADER2
)update test set header1= header2 where tempid = 1select *
into #
from test order by header2, id descselect header1, header3 from #drop table #, test