一个复杂的行列变换表头的问题

[flyblackcat]

我有一句 select lable1,value1,label2,value2 from table where ....

得到的结果是

lable1|value1|label2|value2
---------------------------
book,somebook,date,somedate

如何能让返回的事

book | date
---------------------------
somebook,somedate

求教........

[flyblackcat]

cool， 谢谢 ccdzzr.

[csdyyr]

create table tb(label1 varchar(10),value1 varchar(10),label2 varchar(10),value2 varchar(10))
insert tb
select 'book','somebook','date','somedate' 

declare @sql varchar(8000)
set @sql=''
select @sql=@sql+','+' value1 as '''+label1+''','+' value2 as '''+label2+''''
from tb

set @sql='select '+stuff(@sql,1,1,'')+' from tb'
--print @sql
exec(@sql)

drop table tb
/*

book       date       
---------- ---------- 
somebook   somedate
*/

[flyblackcat]

为什么我没有可用分阿 5555~