Hi,
I am trying to write a filter that produces the following :-
SELECT
*
FROM
[MyTable]
WHERE
(
([StartDate] >= @StartDate
AND
[EndDate] <= @EndDate )
OR
([EndDate] >= @StartDate
AND
[EndDate] <= @EndDate )
OR
([StartDate] <= @StartDate
AND
[EndDate] >= @EndDate )
)
AND
([Status] = @Status)
All attempts so far have failed, could anyone please help?