Subject Re: [firebird-support] Cross Tab queries
Author Ruggero Maffei
> No, Fb 1.0 does not. Fb 1.5 does support CASE..WHEN.

Thank you for yuor reply!
So in FB1.5 it will be possible to use:

SELECT companyname,
SUM (CASE WHEN productname='Box' THEN 1 ELSE 0) as 'BOX',
SUM (CASE WHEN productname='Package' THEN 1 ELSE 0) as 'Package'

> Use a selectable stored procedure or change to 1.5. :-)

Now i start studying the selectable stored procedure.