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

I've used a UNION clause to resolve this type of problem. Of course the UNION clause if very slow, and I've only used it this way as a one time conversion for migrating data from a denormalized form to a normalized form.
i.e.

select id,data,hour1 hour
from tbl
union
select id,data,hour2
from tbl
...

tony 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
Received on Thu Jul 29 1999 - 10:17:00 CDT