Hi all,

I am using SQL 2000, and I have following table with 2 columns, ID and TIME

ID | TIME
A | 07:01
A | 12:05
A | 13:01
A | 15:09
B | 15:07
C | 06:52
C | 12:47
C | 17:03
D | 07:00
D | 18:12
D | 18:57
D | 21:04

Now i want to transpose them into another existing table with 7 fixed columns: ID, T1..T6
...