rich wrote:
>
> Is there a way to save the results of a crosstab as as table or view?
>
> rich
The only way is to output to a file then load that file to a table.
But, you can get the same information, organized differently:
cross sum ClmA for ClmB by ClmC FROM Table
vs:
select ClmB, ClmC, sum(ClmA) from Table GROUP BY ClmB, ClmC
the latter provides the same information, organized in a way that it will go directly
into a table if you wish, or can be set up as a view. Since the latter form follows
the relational model, it is easier to use for further processing.
Jim Blackburn
Kodiak
