VReport general idea

Thu Feb 26 07:57:34 CST 2009

On 2/26/09 3:47 PM, "Beatrix Willius" <bwillius at gmx.de> wrote:

Hi Beatrix,

> Oh my god!!! This is much too complicated. What about a simple pivot query?
> Group the data as you need it and do a pivot over it with the count.

Yes, will be great to see here how that big query can be replaced on PIVOT.
Valentina supports PIVOT

Just Beatrix, as Thorsten point, this EXAPLINS way in background.
    also this way will work for most dbs. Even if there is no PIVOT.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]