Re: Challenging Question

"Raja Botham" <raja_kommuri_at_yahoo.com> wrote in message news:ae473522.0409180759.771c3371_at_posting.google.com...
| Thanks for the responses...
|
| Yes,, the table is existing out there and it looks something like
| this,,,,
|
| create table XX ( id number, total_amount, jan00 , feb00, ...
| ,sep04,oct04,...nov10,dec10);
|
| I am forced to use this table as any changes to the table and
| ,therefore, a total change in the calling procedure would mean a lot
| of time for re-designing and testing.
|
| The way I am looking at doing this is to dynamically get the value
| 'SEP04=30','OCT04=40' etc., and then insert this in the script.. But I
| am falling little too short of making it happen,,, I have the idea
| intact but all I request from you is a hint/suggestion to make it
| happen..
|
|
| Once again, thanks for the responses.
| --raja
|

raja,

really not too clear what you're trying to do

but first, and observation... if at all possible, even if it requires changing the calling procedure, try to get rid of the denormalized table -- it will cause more headaches than the time it takes to change your interfaces. if it is necessary to preserve it, then it should be treated as what it is, a denormalized table with derived data, data that are derived from and maintained in a normalized table

that being said, could you please describe your process a little better...

what are your input values?
where are they coming from?
what is your end-user interface? (C/C++, .NET, Oracle Forms, URL, Java, SQL*Plus?)
are all values for a particular row in XX being supplied at the same time? or are you updating different values in existing rows? what does one row in XX represent?

also, are you onsite with the customer and able to discuss requirements and implementation options with him/her?
or do you have other business analysts available on your project that can assist in analyzing the business need and how best to implement it?

++ mcs Received on Sat Sep 18 2004 - 12:00:15 CDT