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? 

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 1 mth agoLast active
  • 18Views
  • 1 Following