日期:2014-05-18 浏览次数:20589 次
create table car (TrainerName varchar(10), Sessionx varchar(5), ClassName varchar(30), Dates date) insert into car select 'Benjamin', 'AM', 'CRS TRAINING', '2012-03-08' union all select 'Benjamin', 'AM', 'CRS TRAINING', '2012-03-09' union all select 'Benjamin', 'AM', 'Microsoft Exchange Server 2010', '2012-03-08' union all select 'Benjamin', 'AM', 'Microsoft Exchange Server 2010', '2012-03-09' select TrainerName, Sessionx, ClassName0, [2012-03-08], [2012-03-09] from (select TrainerName, Sessionx, ClassName ClassName0, ClassName ClassName1, Dates from car) t pivot(max(ClassName1) for Dates in ([2012-03-08],[2012-03-09])) t TrainerName Sessionx ClassName0 2012-03-08 2012-03-09 ----------- -------- ------------------------------ ------------------------------ ------------------------------ Benjamin AM CRS TRAINING CRS TRAINING CRS TRAINING Benjamin AM Microsoft Exchange Server 2010 Microsoft Exchange Server 2010 Microsoft Exchange Server 2010 (2 row(s) affected)