Forum Discussion
qlegoff
8 years agoFrequent Visitor
Dynamic query parameter filtering SQL database
Hi everyone, I have an issue when I try to filter my SQL server statement with a query parameter generated from a dynamic list. Concretely, I have a parameter which is a distinct value from a...
v-danhe-msft
8 years agoMicrosoft Employee
Hi qlegoff,
Based on my research, you could refert to this article to pass Parameters to SQL queries: https://www.excelguru.ca/blog/2016/04/28/pass-parameters-to-sql-queries/
Regards,
Daniel He
- qlegoff7 years agoFrequent Visitor
Unfortunately, it did not work with my case. Still the same problem.
For now, I just set another parameter where I copy the value from the list above and it works.