I got a requirement to execute a macro within a macro.
Below is the example,
Replace Macro Macro1
INSERT INTO Table1
FROM volatile_value as t_bulk
Thanks Dieter. Figured that out.
went for a different solution today.
Join the volatile_value table for "Version" with MYMACRO.
So i wont need version as parameter and wouldnt need a SP as well.
My Macro will only hve user_id as parameter.
hope it works ;-)