The
query parameters (see
Query Parameters) are evaluated when the query is parsed. For repeat queries, this occurs when the query is defined, which means the values will be fixed at execution time, regardless of the values sent when executed.
Repeat query parameters that take on unique values at execution time are possible using an extension to the query parameter mechanism described in (see page
Query Parameters. These extended parameter markers take the form: