SELECT *
FROM TEMP_TABLE
WHERE ('20100626' BETWEEN start_date_time AND stop_date_time) OR ('20100628' BETWEEN start_date_time AND stop_date_time) or ('20100626' <start_date_time and '20100628' > stop_date_time)
SELECT stop_date_time,start_date_time FROM TEMP_TABLE
INTERSECT
SELECT '20100626 07' AS stop_date_time,'20100629 08' AS start_date_time
FROM TEMP_TABLE2