I have the stored procedure with @StartDate and @EndDate parameters
my WHERE statement is using those parameters to filter out data
WHERE condition1 and SomeDate >= @StartDate and SomeDate <= @EndDate and condition2
However when @StartDate or @EndDate is null or empty string then WHERE statement should look like below
WHERE condition 1 and condition2
I was trying already to do it with CASE of IF statement but without success so far.