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!