|Subject||Re: [firebird-support] Cross Tab queries|
> 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:
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.