Tahnks a lot. Michalels sequence works flawlessly. And it is really
elegant :)
John Machin wrote:
>A few quick silly questions:
>Have you read the Python tutorial?
>Do you read this newsgroup (other than answers to your own questions)?
>Could you have done this yourself in a language other than Py
McBooCzech wrote:
> Hallo all,
>
> I am trying to generate SQL SELECT command which will return pivot
> table. The number of column in the pivot table depends on the data
> stored in the database. It means I do not know in advance how many
> columns the pivot table will have.
>
> For example I will
Thanks for your comment but I am NOT looking for the answer to the
question: "Which SQL command will return requested pivot table"(anyway
it will be an OFF TOPIC question here). My SQL SELECT statement works
fine with Firebird 1.5! What I am looking how to generate this SELECT
using Python. Anyway
McBooCzech wrote:
Hallo all,
I am trying to generate SQL SELECT command which will return pivot
table. The number of column in the pivot table depends on the data
stored in the database. It means I do not know in advance how many
columns the pivot table will have.
For example I will test the databa
McBooCzech wrote:
> Hallo all,
>
> I am trying to generate SQL SELECT command which will return pivot
> table. The number of column in the pivot table depends on the data
> stored in the database. It means I do not know in advance how many
> columns the pivot table will have.
>
> For example I will
Hallo all,
I am trying to generate SQL SELECT command which will return pivot
table. The number of column in the pivot table depends on the data
stored in the database. It means I do not know in advance how many
columns the pivot table will have.
For example I will test the database as following:
