求大家幫忙﹐一個關于數據庫的問題﹐高分求救﹗﹗﹗

[zhiri]

我有二個表﹐
一個為A
t01 t02 t03 t04 t05 t06 r01 r02 r03 r04 r05 r06
另一個為B
t1 t2 t3 t4 t5 t6 r1 r2 r3 r4 r5 r6

t01---t06和t1---t6中記錄的是打卡時間
如t01為2003/9/1 08:20 t1為2003/9/1 17:30
或者t01為空而t1為2003/9/1 08:20 t02為2003/9/1 17:30
要并成另一個表C
T01---T06 R01---R06
c表中的T01為A和B在同一天的最早時間﹐T02為A和B在同一天的次早時間。
總之A表及B表的打卡記錄如果是在同一天的話﹐就得把這兩個表的兩條記錄分時間先后并成一條記錄﹐
另如果不是在同一天則分別按日期追加到C中
請高手幫忙呀﹐高分散了﹐最后50分全給!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[zhiri]

另最后給個實例!!!!!!!!多謝﹗﹗﹗

[seesea125]

难，友情up

[zhiri]

快幫我解決呀﹐各路高手﹐大俠﹗﹗﹗

[webdiyer]

SQL问题，到SQL Server组去找大力啊！

[gong1]

jiushi

[zhiri]

ai

[seesea125]

难，想想重新设计一下表的结构

[zhiri]

高手呢﹖高手都到哪里去了

[dahroswell]

select empid,empno,
(case when (select count(*) from dbo.#Temp_smp_kqdata where empid=x.empid and empno=x.empno and kqdate=x.kqdate and kqtime<=x.kqtime)=1 then kqdate+' '+kqtime end) as t1,
(case when (select count(*) from dbo.#Temp_smp_kqdata where empid=x.empid and empno=x.empno and kqdate=x.kqdate and kqtime<=x.kqtime)=2 then kqdate+' '+kqtime end) as t2,
(case when (select count(*) from dbo.#Temp_smp_kqdata where empid=x.empid and empno=x.empno and kqdate=x.kqdate and kqtime<=x.kqtime)=3 then kqdate+' '+kqtime end) as t3,
(case when (select count(*) from dbo.#Temp_smp_kqdata where empid=x.empid and empno=x.empno and kqdate=x.kqdate and kqtime<=x.kqtime)=4 then kqdate+' '+kqtime end) as t4
into aa
from dbo.#Temp_smp_kqdata x