數據庫轉換問題﹐思歸﹐大力﹐幫幫我﹗﹗﹗﹗﹗﹗﹗﹗﹗
求各路高手幫忙﹐我有這樣一個表A
empid empno empdate emptime
1756 AA000042 2002-05-19 60328
1756 AA000042 2002-05-19 60332
1756 AA000042 2002-05-19 60336
1756 AA000042 2002-05-19 60340
1756 AA000042 2002-05-20 29755
1756 AA000042 2002-06-11 41864
1756 AA000042 2002-06-11 50900
1757 AA000021 2002-05-20 30200
1759 AA000010 2002-12-14 59400
1759 AA000010 2002-12-28 79740
1759 AA000010 2003-04-03 63360
1760 AA000011 2002-05-22 45005
1760 AA000011 2002-05-22 48408
1760 AA000011 2002-05-22 63005
1760 AA000011 2002-05-22 66441
.
.
.
.
.
.
要將上表A轉換為下表B
是按日期不同來轉換成行的
empid empno t1 t2 t3 t4
1756 AA000042 2002-05-19 60328 2002-05-19 60332 2002-05-19 60336 2002-05-19 60340
1756 AA000042 2002-05-20 29755
1756 AA000042 2002-06-11 41864 2002-06-11 50900
1757 AA000021 2002-05-20 30200
1759 AA000010 2002-12-14 59400
1759 AA000010 2002-12-28 79740
1759 AA000010 2003-04-03 63360
1760 AA000011 2002-05-22 45005 2002-05-22 48408 2002-05-22 63005 2002-05-22 66441
高分相贈﹐謝謝各位大俠了﹗﹗﹗
思歸﹐大力﹐幫我﹗﹗﹗