Re: Is there an SQL to create a view that will normalize a denoramlized table?

Home -> Community -> Usenet -> c.d.o.server -> Re: Is there an SQL to create a view that will normalize a denoramlized table?

From: tony <ramdan_at_mailexcite.com>
Date: 30 Jul 1999 11:49:05 -0500
Message-ID: <lHko3.11843$x7.439392@newscene.newscene.com>

Partly, I still need to id where every hour came from

In article <7nqlfv$98q$1_at_hubble.csuchico.edu>, kelfink_at_ecst.csuchico.edu (Kevin Fries) wrote:
>In article <1HYn3.4545$x7.228281_at_newscene.newscene.com>,
>tony <ramdan_at_mailexcite.com> wrote:
>>we have a table that is normalized 24 hourly reading in one row
>>
>>
>>id date hour1 hour2 .. hour24
>>
>>
>>we need to create a view that is normalized.
>>
>>
>>id date hour1
>>id date hour2
>>
>>
>>any help please!
>
>
>Try a view like:
>
>CREATE VIEW HOURS AS
>SELECT ID, DATE, HOUR1
>FROM thetable
>union all
>SELECT ID, DATE, HOUR2
>FROM thetable
>union all
>....
>..
>..
>..
>SELECT ID, DATE, HOUR24
>FROM thetable
>;
>
>That will show 24 rows.
>is that what you're looking for?
>
>Kevin Fries
Received on Fri Jul 30 1999 - 11:49:05 CDT