SQL Column and Row check to get date between

declare @StDt datetime, @EdDt datetime
set @StDt='2009-06-17 11:00:00.000'
set @EdDt= '2009-06-18 12:30:00.000'
select * from Notification N
where
(N.Start_DateTime between @StDt and @EdDt
or N.End_DateTime between @StDt and @EdDt
or @StDt between N.Start_DateTime and N.End_DateTime
or @EdDt between N.Start_DateTime and N.End_DateTime)