dynamic view/crosstab query question

From: Mike Stenzler <mstenzler_at_ssaris.com>
Date: Fri, 12 Mar 2004 14:45:17 -0500
Message-ID: <0ro4c.21515$B54.15945@fe28.usenetserver.com>

Hi.

I'm wondering if there's a way to effectively apply a "crosstab" view upon a table.

I have a table with column such:

date        name    type    value
1/1/03    A            E        123
1/1/03    A            F        235
1/1/03    B            E        999
1/1/03    C            E        888
1/1/03    C            F        777
1/2/03    A            E        234
1/2/03    A            F        237
1/2/03    B            E        991
1/2/03    C            E        889
1/2/03    C            F        766

.
.
.

and so on...

I'd like to create a view or query that would allow me to look at this data in the fashion below:

date        type    name    name    name...
                           A         B         C       ...
1/1/03    E            123     999      888    ...
1/2/03    E            234     991      889    ...
1/3/03    E            ...       ...          ...    ...

1/1/03    F            235                 777    ...
1/2/03    F            234     991      766    ...
1/3/03    F            ...        ...          ...      ...

Is it possible to create a view on a table that extends "sideways" dynamically as names are added? And how would one transpose the data presented in the table into the "crosstabbed" view of that data?

Thanks in advance for any ideas and help.

Mike Received on Fri Mar 12 2004 - 13:45:17 CST