[阅读: 326] 2005-01-06 08:23:15
select SDate, EDate,
(Select count(*) from TableA as T2
WHERE (T2.SDate < T1.SDate and T2.EDate > T1.SDate)
or (T2.SDate < T1.EDate and T2.EDate> T1.EDate)
)
from TableA as T1
DISSENT IS THE HIGHEST FORM OF PATRIOTISM !
--Thomas Jefferson
| -ICP -IDC -ISP |