create table #stud (
studentID int,
studentName varchar(50),
kemu varchar(20),
int)
insert into #stud values(1001,'xiaowang','net',84)
insert into #stud values(1002,'xiaoli','net',80)
insert into #stud values(1003,'xiaoliu','net',86)insert into #stud values(1001,'xiaowang','sql',84)
insert into #stud values(1002,'xiaoli','sql',80)
insert into #stud values(1003,'xiaoliu','sql',86)insert into #stud values(1001,'xiaowang','xml',84)
insert into #stud values(1002,'xiaoli','xml',80)
insert into #stud values(1003,'xiaoliu','xml',86) declare @sql varchar(8000)
select @sql = ''
select @sql = @sql + ','+kemu+'=sum(case kemu when '''+kemu+''' then else 0 end)'
from #stud
group by kemuexec('select studentname '+@sql+' from #stud group by studentname')drop table #stud
studentID int,
studentName varchar(50),
kemu varchar(20),
int)
insert into #stud values(1001,'xiaowang','net',84)
insert into #stud values(1002,'xiaoli','net',80)
insert into #stud values(1003,'xiaoliu','net',86)insert into #stud values(1001,'xiaowang','sql',84)
insert into #stud values(1002,'xiaoli','sql',80)
insert into #stud values(1003,'xiaoliu','sql',86)insert into #stud values(1001,'xiaowang','xml',84)
insert into #stud values(1002,'xiaoli','xml',80)
insert into #stud values(1003,'xiaoliu','xml',86) declare @sql varchar(8000)
select @sql = ''
select @sql = @sql + ','+kemu+'=sum(case kemu when '''+kemu+''' then else 0 end)'
from #stud
group by kemuexec('select studentname '+@sql+' from #stud group by studentname')drop table #stud
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货