Dynamic SQL Queries in Excel

[@SpiritofWe]

Thank you for sharing!

[@thuvu490]

very helpfull, tks so much

[@MrMrbond77]

i like your tip, tks a lot!!!!

[@gaybarile4232]

Thank you for this video. This is very helpful for me.

[@venkyr81]

WoW! Excellent Video. Thanks for very very useful tips. This will help me to create a dynamic sql query using power query.

[@jacoh9591]

Thanks - First easy and effective solution that I've come across

[@nathalievanya]

Worked well! Thanks so much!

[@BrijeshYadav-vl7bj]

Very informative. Is there a way to add say 2 more values/parameters but those can be optional.

[@data-literate]

@@BrijeshYadav-vl7bj yes, you can add as many parameters using the same technique as you want. If there are multiple values, you will probably need to create an IF statement to generate the parameter SQL command text.

[@EPaulofficiel]

Very useful video, and thank you for it. However, it doesn't work for oracle sql, how can i fix this please? it seems it is a format issue..

[@twmagaluk]

Thanks! Was just what I was looking for!
I was wondering about another type of parameter. I am running a SQL behind the scenes in Excel and am trying to pull values that are for example IN (1, 4) is there a way to dynamically change the values within the parentheses based on some table? For instance have checkboxes that when clicked on and off may show IN (1, 2, 5) instead.

[@data-literate]

@@twmagaluk ya, you can do that.
You would have to set up an excel formula in one cell that generates the sql parameter, then apply in the same manner.

[@twmagaluk]

@@data-literate Thanks a bunch! I found a way of doing that through an intermediate concatenate statement. Thanks for the response!