declare @t table(No char(3),Area int,Kind nchar(1))
insert @t select '123',10,N'大'
insert @t select '123',20,N'中'
insert @t select '123',30,N'小'
select No,max(case when Kind=N'大' then Area end) as [大],
max(case when Kind=N'中' then Area end) as [中],
max(case when Kind=N'小' then Area end) as [小]
from @t
group by No
/*
No
大
中
小
---- ----------- ----------- -----------
123
10
20
30
(所影响的行数为 1 行)
*/