Requirement: Build one filter query based on input parameter(s), if input=v1, filter no records, else return rows which satisfy column=input
Implementation:
select * from t1
where (v1=@input1 or c1=@input1) and (v2=@input2 or c2=@input2)
Requirement: Build one filter query based on input parameter(s), if input=v1, filter no records, else return rows which satisfy column=input
Implementation:
select * from t1
where (v1=@input1 or c1=@input1) and (v2=@input2 or c2=@input2)