execute dynamic sql in Mode
I'm thinking of making a dash that has a parameter containing a list of table names (snapshots, tables with same name plus date), and when one of the parameters is selected, to run a select from the table name chosen. Basically I need to utilize dynamic sql. I was thinking of putting the execute in a stored procedure. I tried it out but Mode says no permission to call a stored procedure. Is there a work around to do what I want to do in Mode?