willjx
asked on
Unwanted parameter requests
Running a large query i am getting unwanted parameter requests.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
do the query by steps - until you find the step with "unwanted parameter requests"
willjx,
Yes, when posting a question about a query, please post the SQL.
Yes, when posting a question about a query, please post the SQL.
If your query uses another query as part of the SQL, then it is possible that one of the nested queries contains the parameter. If that is the case, you may have to define the parameter in the original query, and in all subsequent queries that use the other query.