Re: [firebird-support] FIREBIRD PIVOT function or Matrix

So write yourown udf in your favourite language or write stored procedure eg. make_crosstab(sql varchar(500)) which parse sql and create crosstab selectable procedure in fly from given sql. You will be able to select * from crosstab as in postgres. -- regards, Michał Kurczabiński

RE: [firebird-support] FIREBIRD PIVOT function or Matrix

-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 15 February 2017 11:53 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] FIREBIRD PIVOT function or Matrix On 14-2-2017 15:48, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

On 14-2-2017 15:48, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 14.02.2017 14:15, 'Stef' s...@autotech.co.za [firebird-support] wrote: >> Any suggestions on my DB design and query to display the values in matrix >> (pivot) format? > >Simple client-side code can show you

RE: [firebird-support] FIREBIRD PIVOT function or Matrix

-support] Subject: Re: [firebird-support] FIREBIRD PIVOT function or Matrix I go with Sean. Btw, this is already in the tracker: http://tracker.firebirdsql.org/browse/CORE-1738 Vote on it! Carlos www.firebirdnews.org - www.FireBase.com.br >> > Any suggestions on my DB design

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

I go with Sean. Btw, this is already in the tracker: http://tracker.firebirdsql.org/browse/CORE-1738 Vote on it! Carlos www.firebirdnews.org - www.FireBase.com.br >> > Any suggestions on my DB design and query to display the values in matrix >> (pivot) format? >> >>Simple client-side

RE: [firebird-support] FIREBIRD PIVOT function or Matrix

> > There are times when I would love to be able to pivot data on the > > server, to further process the data an SP. > >SP cannot process queries with unknown number of fields. Neither client > part, BTW. Who said that the number of columns/fields was unknown? I could want to deal with a

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

@yahoogroups.com Sent: Tuesday, 14 February 2017, 17:48 Subject: Re: [firebird-support] FIREBIRD PIVOT function or Matrix 14.02.2017 14:15, 'Stef' s...@autotech.co.za [firebird-support] wrote: > Any suggestions on my DB design and query to display the values in matrix > (pivot) format?

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

14.02.2017 16:31, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > There are times when I would love to be able to pivot data on the server, to > further > process the data an SP. SP cannot process queries with unknown number of fields. Neither client part, BTW. > Also,

RE: [firebird-support] FIREBIRD PIVOT function or Matrix

> > Any suggestions on my DB design and query to display the values in matrix > (pivot) format? > >Simple client-side code can show you the matrix in any convenient form. > There is no point to do that on server. I disagree! There are times when I would love to be able to pivot data on

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

14.02.2017 14:15, 'Stef' s...@autotech.co.za [firebird-support] wrote: > Any suggestions on my DB design and query to display the values in matrix > (pivot) format? Simple client-side code can show you the matrix in any convenient form. There is no point to do that on server. -- WBR,