Hello @Bommisetty, Rakesh (Hudson IT Consultant)
Please have a look at the below pipeline, hope it helps with you initial Query!
I have created a Pipeline Variable called 'varValue'
I am verifying the Null Value in the 'If Condition' and then i have added Activity based on the expression result.
@not(empty(variables('varValue')))
Inside the 'If Condition'-->Copy Data-->Query as shown below.
select * from dbo.employeeSource where City!='@{variables('varValue')}'
IF the Condition is True then the True Activity will be executed and and the Query is again using the Pipeline Variable as shown below.