刪除Table中重覆資料

SELECT  *

FROM   [TableName]

WHERE (DATEDIFF(day, [StartDate], CONVERT(DATETIME, @sDate, 102)) >= 0

AND DATEDIFF(day, [EndDate], CONVERT(DATETIME, @sDate, 102)) <= 0 OR

DATEDIFF(day, [EndDate], CONVERT(DATETIME, @eDate, 102)) <= 0 

AND DATEDIFF(day, [StartDate], CONVERT(DATETIME, @eDate, 102)) >= 0 OR

 DATEDIFF(day, [StartDate], CONVERT(DATETIME, @sDate, 102)) <= 0 

AND DATEDIFF(day, [EndDate], CONVERT(DATETIME, @eDate, 102)) >= 0)