Re: SQL Question
Date: 1998/04/20
Message-ID: <353B81DF.7BAA_at_usa.net>#1/1
Joseph Bonner wrote:
>
> I have a research database with a normalized structure. I need to put
> the data into a completely denomalized structure for analysis.
> (...)> Does anybody have sugestions?
>
> Thanks in advance
> Joe B>
Joe,
I would rather create a table and not a view.
It would be much simpler to define all fields in a temporary table (you
may give grants to selected group of people only) with unique RESP ID
for each row, and then do the bunch of different updates of the table ,
calculating sugdate1, sugdate2, tis1 5 as a source from your database.
I'm not an expert but this is the way I'd solve this.
HTH,
Greetings,
Eva Maciasz,
McGill University
Montreal, Canada
Received on Mon Apr 20 1998 - 00:00:00 CEST