Custom query not returning results when using parameters

Hi,

Here is my custom query where I populated the Select statement with the required values. You will see I get a query result returned.

image696×396 13.3 KB

However, when I use parameters, I get no query result.

image701×436 12.6 KB

image698×391 11.4 KB

Why would the query fail to return results when using parameters?

The database is MS SQL.

Thanks,
Ray