请教一个简单的交叉表查询

[piaozi2003]

有一个记录员工考勤的表

name date time
A 06-01 8:00
A 06-02 8:01
A 06-03 7:58
...............

想做成这样的形式

name 06-01 06-02 06-03 .........
A 8:00 8:01 7:58 ...........
B ..................................

请问如何写SQL语句？

[fcuandy]

先点右上角的 X

再到贴子列表页面，点搜索，关健字'行转列'

[angel8601]

lZ按照楼上的去找,你的这个问题有案例

[子陌红尘]

declare @s varchar(8000)
set @s=''
select @s=@s+',['+date+']=max(case date when '''+date+''' then time end)' from 考勤表 group by date order by date
set @s='select name'+@sql+' from 考勤表 group by name order by name'
exec(@s)

[子陌红尘]

declare @s varchar(8000)
set @s=''
select @s=@s+',['+date+']=max(case date when '''+date+''' then time end)' from 考勤表 group by date order by date
set @s='select name'+@s+' from 考勤表 group by name order by name'
exec(@s)

[xyxfly]

行转列～ 同意楼上的 ：）