Looking For "Elegant" Solution [message #3081] |
Tue, 03 September 2002 13:51 |
Rizwan Qazi
Messages: 135 Registered: August 2002
|
Senior Member |
|
|
In a curent solution specific values are added from new table and added to the existing table as EMP_CONSOLIDATE for e.g.
-EMPLOYEE_199906- with fields...
CONTRACT_NO
BALANCE
CREDIT_LIMIT
-EMPLOYEE_199907- with fields...
CONTRACT_NO
BALANCE
CREDIT_LIMIT
-EMPLOYEE_199908 - with fields...
CONTRACT_NO
BALANCE
CREDIT_LIMIT
Are Currently stored in table EMP_CONSOLIDATE as
CONTRACT_NO
BALANCE_199906
CREDIT_LIMIT_199906
BALANCE_199907
CREDIT_LIMIT_199907
BALANCE_199908
CREDIT_LIMIT_199908
If a new table
-EMPLOYEE_199909- with fields...
CONTRACT_NO
BALANCE
CREDIT_LIMIT
is added the table EMP_CONSOLIDATE is altered to look like
EMP_CONSOLIDATE as
CONTRACT_NO
BALANCE_199906
CREDIT_LIMIT_199906
BALANCE_199907
CREDIT_LIMIT_199907
BALANCE_199908
CREDIT_LIMIT_199908
BALANCE_199909
CREDIT_LIMIT_199909
This table is used for reporting purposes. Can anyone think of a more "elegant" solution for this using a table structure which does not require the addition of extra columns
Thanks
Riz
|
|
|
|