I am connecting to Teradata using SSRS and have multiple parameters, many of them that seek multiple values.
The challenge is all these parameters may not be always filled, sometimes it could be blank. So I am using a logic as below -
Select * from Table
Where
(Param1 in (?) or ? = '')
AND
(Param2 in (?) or ? = '')
AND
(Param3 = ? OR ? = '')
This gives an error stating Something expected like a Precedes or Exists or In or contains ..........,
Anyone experienced similar issue? Please help.