user parameter in dynamic query

Hello!   I'm trying to pass the value of a parameter to my dynamic query statement so that I can limit the dataset on the source db (dealing with extremely large data).   I tried the following......