写个存储过程:
create procedure sp
as
declare @sql varchar(3000)
set @sql=''
set @sql='select 姓名'
select @sql=@sql+',min(case 日期 when '''+日期+''' then 内容 end)['+日期+']'
from (select distinct 日期=cast(日期 as varchar(30)) from test)a
set @sql=@sql+' from test group by 姓名'
exec(@sql)
写个存储过程:
create procedure sp
as
declare @sql varchar(3000)
set @sql=''
set @sql='select 姓名'
select @sql=@sql+',min(case 日期 when '''+日期+''' then 内容 end)['+日期+']'
from (select distinct 日期=cast(日期 as varchar(30)) from test)a
set @sql=@sql+' from test group by 姓名'
exec(@sql)