Subject | Re: [firebird-support] Pivot Table |
---|---|
Author | Adriano dos Santos Fernandes |
Post date | 2008-08-07T13:51:52Z |
PROSPER IT, Ryszard Lewandowski escreveu:
AFAIU, MSSQL pivot table columns are not dynamically.
In FB, you could mount the column values using CASE or DECODE.
Adriano
> Thanks, but unfortunately I need to create dynamic columns (differentAnd can't you dynamically create the SQL statement in the client?
> result sets).
>
AFAIU, MSSQL pivot table columns are not dynamically.
In FB, you could mount the column values using CASE or DECODE.
Adriano