Conditional WHERE clause in SQL

Hi Gurus,

I have this query where I want to convert my lexical parameter in just putting the conditions in the where clause.

My sample scenario is initially the conditions were put in a lexical param(in report builder). To determine what WHERE condition(between 1 and 2 condition) is base on a SELECT INTO with parameters.

But im encountering the issue, that the user is able to run the report without the parameters(as a requirement) so my report would fail because of too_many_rows,

Then i handled that exception using the too_many_rows

BUT my problem now is I have to give both conditions,