create table test(
startdate date,
enddate date
)
insert test VALUES('2018-9-1','2018-9-10')
insert test VALUES('2018-8-30','2018-9-5')
insert test VALUES('2018-8-25','2018-8-30')
declare @Start nvarchar(32)
declare @End nvarchar(32)
set @Start='2018-9-3'
set @End='2018-9-5'
select * from test where (enddate>=@Start and enddate<=@End) or (startdate>=@Start and startdate<=@End) or (startdate<@Start and enddate>@End)