Re: view question - is this possible?

When using SQL to extract data you're often using the SQL to denormalising the data to make it easier to understand.

SQL is useful for denormalising 2nd and 3rd normal forms but can't do first normal form very easily.

1st normal form being arrays.

To do this you really need cross tabs functionality as used in MS access and, presumably, SQL sever.

L Lee wrote:

> The problem I'm having is how to create a view using the following table:
> These are the records for a single service ID having multiple consumption
> records like the following. The dates are not consistently one month
> apart.
> cust id date consumption
> 123 Jan1 10
> 123 Feb1 12
> 123 Mar1 11
> 123 Mar30 13
>
> The users want to see all the discrete reads. So we want to create a view
> for the users to show the records like this:
> cust id 1stdate consump 2nddate consump 3rddate consump 4thdate consump
> 123 Jan1 10 Feb1 12 Mar1 11 Mar30 13
>
> Can anyone help me with how this could be done?
> Thank you in advance.
>
Received on Sat Sep 25 1999 - 18:16:27 CDT