SQL Server表竖列转横向显示代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】 SQL Server表竖列转横向显示

作者:Dezai.CN / 发布于2012/5/10/ 774

<div>
<div id="cnblogs_post_body">
----------联合查询结果集存入临时表
select * into ##tmpa from (select wh_WhName,sum(ps_DiscountMoney) as moneys,psr.wh_Id,Convert(varchar(10),ps_PSRTime,120) as ps_PSRTime
from PosSaleRecord as psr inner join wareHouse as wh on wh.wh_Id=psr.wh_Id group by psr.wh_Id,wh_WhName,Convert(varchar(10),ps_PSRTime,120)) a
----------把临时表竖列转换横向显示
declare @sql varchar(8000) --将竖列横向显示
set @sql = 'select ps_PSRTime ' 
select @sql = @sql + ' , (case wh_whname when ''' + wh_whname + ''' then moneys else 0 end) [' + wh_whname + ']'
from (
select distinct wh_whname from ##tmpa
) as a 
set @sql = @sql + ' into ##tmpPPPt from ##tmpa'
exec(@sql)
----------查询临时表
select * from ##tmpa 
select * from ##tmpPPPt
----------删除临时表
drop table ##tmpPPPt
drop table ##tmpa
</div>
</div>

试试其它关键字

　竖列转横向显示　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)