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