--创建两个表,把你的数据写到表中
create table baoxiu ( bxid varchar(10),name varchar(100))
go
create table jilu ( bxid varchar(10),list varchar(100),[time] datetime )
go
--然后运行下面的语句
declare @id int
declare @time varchar(100)
declare @sql varchar(max)
set @sql = ' select a.bxid,b.name,'
declare cur_jilu cursor for
select distinct [time] from jilu
open cur_jilu
fetch cur_jilu into @time
while @@FETCH_STATUS = 0
begin
set @sql = @sql + ' max(case when [time] = ''' + @time + ''' then list else '''' end ) [list'+@time + '],'
fetch cur_jilu into @time
end
close cur_jilu
deallocate cur_jilu
set @sql = @sql + '1 noshow from jilu a, baoxiu b where a.bxid = b.bxid group by a.bxid,b.name order by a.bxid '
exec (@sql)