记录打横显示

declare @Sql varchar(2000)
set @Sql='select VoteDept,Title,UNIT,UserDept,UserName,[name],OptionId'
select @Sql=@Sql+',sum(case [name] when *'+[name]+'* then [point] else 0 end) as *'+[name]+'*'
 from(select distinct [name] from VoteDetalView) as temp

 

set @Sql=@Sql+' from VoteDetalView group by VoteDept,Title,UNIT,UserDept,UserName,[name],OptionId order by VoteDept,Title'

select @Sql= replace(@Sql,'*','''')

print @Sql
exec (@Sql)