Re: Variable Table name in Stored Procedure issue

[A G]

Hi Irek,
Firstly, thank you for reading.
I like the method you have mentioned.
However, upon thinking a little, I got to a simple way.
Option 4)
I created a new table name from the incoming unique table name
I then converted all the functions into stored procedures.
The new stored procedure accepts this new table name as an IN param.
These new stored procedures allow dynamic sqls, so changed the hardcoding in the accessing of the variables to dynamic (as compared to the prev. code)

So, in summary, I converted the functions to stored procedures.

Seems to be working as of now. Please feel free to point out any flaw in this method.
Thanks for reading,
Amit