declare @sql varchar(8000)
set @sql = 'select employeeName '
select @sql = @sql + ' , max(case ckDate when ''' + convert(nvarchar,ckDate) + ''' then score else 0 end) [' + convert(nvarchar,ckDate) + ']'
from (select DISTINCT ckDate ,remark from SM_FiveSCheck) as a
set @sql = @sql + ' from SM_FiveSCheck group by employeeName'
exec(@sql)
源码如上,结果
姓名 20110718 20110709 20110708 20110728 20110715 20110727
刘凯 0 0 0 0 0 0
李笑营 0 0 0 0 0 0
周勇亮 0 0 0 0 0 0
陈梅 0 0 0 0 0 0
王颖 0 0 0 0 0 0
徐娅娅 0 0 0 0 0 0
张国栋 0 0 0 0 0 0
魏梦琦 0 0 0 0 0 0
我还有一列remark,我想在每个日期后面在显示个remark,还有让日期按照自然日期排序,而不是这么乱,