Hello,
I just wanted to make a quick post about something coming in Monday's beta. Something that few people will find unless it's documented somewhere.
When using SQL Files as the query source, you can right-click on the filename box and choose "Variables". Until now, variables here were meant as part of the file name, like c:\temp\%my_awesome_variable%\test.sql. That works.
What does NOT work, until now, is using this variable as a means to pass a parameter into the SQL file. Like so:
In which case, the corresponding SQL File would reference the first parameter as &1, the second as &2, and so on. For example:
I hope someone finds this helpful.
-John