SQL Server: Conditional parameter in WHERE clause
I have a query where I have to pass the parameter only if it has a value. I want to pass jobID
and workorderID
only if it has value not null. I tried CASE
but with AND
, it’s not working
I have a query where I have to pass the parameter only if it has a value. I want to pass jobID
and workorderID
only if it has value not null. I tried CASE
but with AND
, it’s not working