Hi everyone

Is it possible to pass variables into a stored procedure that can be
used as the names of fields or tables, so that the same stored
procedure can effectively be used on different tables?

Maybe it is possible to put together sql strings in a stored procedure
that can then somehow be executed in the procedure itself?

Any thoughts on this would be greatly appreciated.
Thanks
Will