Subject Re: [firebird-support] Pivot Table
Author Adriano dos Santos Fernandes
PROSPER IT, Ryszard Lewandowski escreveu:
> Thanks, but unfortunately I need to create dynamic columns (different
> result sets).
>
And can't you dynamically create the SQL statement in the client?

AFAIU, MSSQL pivot table columns are not dynamically.

In FB, you could mount the column values using CASE or DECODE.


Adriano