Subject Re: Table name as variable in SQL
Author wojciech_materna
> Of course, you can use 'execute statement' or many IFs in the
> stored procedure, but if I were you, I'd put all data into one
table.
> I have no idea why many tables with the same structure and
containing
> about the same data may exist. May be the developer must learn
> something about dababase design?.. I've heard about something
called
> "normal forms"...
> --
> SY, Dimitry Sibiryakov.


OK,I understand. That is becouse of compatibility to our old
software and to have possibility to manage old data without
interactions with today's. Many reasons, I know that few of them are
not very strong, by some are very important for us.

Anyway thanks

Wojtek