数据库类似行列转换SQL
declare @sql nvarchar(4000)select @sql=isnull(@sql+',','')+t.name
from (select distinct quotename(name) as name from test) t
set @sql='select * from (SELECT date,name,sum(num) num FROM testGROUP BY date,name) t pivot ( sum(num) for t.name in ('+@sql+')) as a'
exec(@sql)
页:
[1]