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

From: Paul Q <paulq_at_home.com>
Date: Thu, 29 Jul 1999 22:59:59 GMT
Message-ID: <P15o3.16056$um6.190162@news2.rdc1.on.home.com>

create view xxx as
select id,

           date,
           hour1
       from table

union
select id,

           date,
            hour2

  from table

    .
    .
    .

tony wrote in message <1HYn3.4545$x7.228281_at_newscene.newscene.com>...
>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!
Received on Thu Jul 29 1999 - 17:59:59 CDT