vinyeah: 再李大师的基础上,偶改了改,现在搞定了 [阅读: 398] 2005-01-06 09:02:38 select * from ( 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) ) as cnt from TableA as T1 ) where cnt > 0