...sqlserver数据库 时间格式: 2011-03-24 19:00:39.000
发布网友
共1个回答
热心网友
declare @sql nvarchar(max)
select @sql=stuff((select ','+quotename(convert(varchar,number)) from master..spt_values where type='P' and number<24 for xml path('')),1,1,'')
set @sql='select * from (select userid,datepart(hh,time)time,sum(comment)sc from tb group by userid,datepart(hh,time))t
pivot (sum(sc) for time in ('+@sql+'))a'
--select @sql
exec(@sql)
