SQL 对结果集排序

[寡亾]

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，还有让日期按照自然日期排序，而不是这么乱，

[AcHerat]

from (select DISTINCT ckDate ,remark from SM_FiveSCheck) as a
order by ckDate

[AcHerat]

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) + ']'
	+ ',max(case ckDate when ''' + convert(nvarchar,ckDate) 
	+ ''' then remark else '''' end) [' + convert(nvarchar,ckDate) + '_remark]'
from SM_FiveSCheck
group by ckDate
order by ckDate
set @sql = @sql + ' from SM_FiveSCheck group by employeeName'
exec(@sql) 

[wangdingbang]

   
                   Select *, row_number() over(order by ckDate) as remark
           From SM_FiveSCheck
  

[--小F--]

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) + 'remark]'
from (select DISTINCT ckDate ,remark from SM_FiveSCheck) as a
set @sql = @sql + ' from SM_FiveSCheck group by employeeName'
exec(@sql) 

[cd731107]

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) + ']'
                   + ' , max(case ckDate when ''' + convert(nvarchar,ckDate) + ''' then remark else 0 end) [' + convert(nvarchar,ckDate) + ']'
from (select  DISTINCT top 100 percent ckDate ,remark from SM_FiveSCheck order by ckDate) as a
set @sql = @sql + ' from SM_FiveSCheck group by employeeName'
exec(@sql) 

[寡亾]

小三正解，谢了。结贴了。