Posted by Steve Jorgensen on 11/29/05 08:23

On Tue, 29 Nov 2005 02:00:46 GMT, Steve <sjc4914@yahoo.com> wrote:

>I am trying to develop a stored procedure for an existing application that
>has data stored in numerous tables, each with the same set of columns. The

In the relational database realm, this is what we call a RED FLAG. If data
has the same set of columns, it should be in the same table. To identify
distinct sets of data within a table, you add one field. Anything else is
going greatly against the grain of how SQL is designed to work, and limits
what you can do with the data.

Tables are structural elements - rows are data elements. RDBMSs are not
designed to use structural elements as data elements.

[Back to original message]