SQL 语句！！！！！！！！
表TT
idno icdate ictime
0000082007/09/2608:00:00
0000082007/09/2612:30:00
0000082007/09/2613:30:00
0000082007/09/2617:00:00
0000082007/09/2700:30:00
得到结果
idno icdate T1 T2 T3 T4 T5 T6 T7 T8
0000082007/09/26 08:00:00 12:30:00 13:30:00 17:00:00 00:30:00 NULL NULL NULL
[解决办法]
我是来学习的
[解决办法]
没看懂
[解决办法]
--如果你的值不满八个,使用静态SQL
create table tb(idno varchar(10),icdate varchar(10),ictime varchar(10))
insert into tb values('000008', '2007/09/26', '08:00:00')
insert into tb values('000008', '2007/09/26', '12:30:00')
insert into tb values('000008', '2007/09/26', '13:30:00')
insert into tb values('000008', '2007/09/26', '17:00:00')
insert into tb values('000008', '2007/09/27', '00:30:00')
go
select idno ,icdate,
max(case px when 1 then ictime end) T1,
max(case px when 2 then ictime end) T2,
max(case px when 3 then ictime end) T3,
max(case px when 4 then ictime end) T4,
max(case px when 5 then ictime end) T5,
max(case px when 6 then ictime end) T6,
max(case px when 7 then ictime end) T7,
max(case px when 8 then ictime end) T8
from
(
select px=(select count(1) from tb where idno=a.idno and icdate = a.icdate and ictime<a.ictime)+1 , * from tb a
) t
group by idno,icdate
drop table tb
/*
idno icdate T1 T2 T3 T4 T5 T6 T7 T8
------ ---------- -------- -------- -------- -------- ---- ---- ---- ----
000008 2007/09/26 08:00:00 12:30:00 13:30:00 17:00:00 NULL NULL NULL NULL
000008 2007/09/27 00:30:00 NULL NULL NULL NULL NULL NULL NULL
（所影响的行数为 2 行）
*/
