22,209
社区成员
发帖
与我相关
我的任务
分享
Declare @sql varchar(max)
set @sql=STUFF((select ','+QUOTENAME([OperateType])) from (select Tracker,OperateType,COUNT(1) as total from ScenicTicketsLog
group by Tracker, OperateType) t group by [OperateType] FOR XML PATH('')) ,1,1,'')
set @sql='select * from (select Tracker,OperateType,COUNT(1) from ScenicTicketsLog
group by Tracker, OperateType) t
pivot (sum([total])for [OperateType] in ('+@sql+')) a '
exec(@sql)