I have quite a few tables which contain some common columns (same name and datatype). On these columns I need to perform the same operations and I would like to do that via a stored procedure. However the only way I can make it work at the moment is using dynamic sql, which I'd rather avoid.
Is there any way to use a stored procedure for different tables (where the table name is handed over as parameter) without using dynamic sql?