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
SELECT *
FROM ....
WHERE
ABS(POS.CosentinoPOTotal - JV.CosentinoTotal) > 0.01
AND S.StepTypeID NOT IN (14,15)
AND Job.JobID = @JobID
AND WO.WorkOrderID = @WorkOrderID