I am trying to write a macro that takes 3 inputs from the user, Database1, Database2 and an integer value.
What I am trying to do, is to automate the "space moving function".
In the macro, I will write the 3 SQL statements
I have been stumped by doing this as the macro, it seems, does not allow to use a variable/parameter in the "from" clause mentioned in step 1.
Any way on how to achieve this would be great!
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.