Thanks all



But this still does not answer my question as to db design and query?



Regards



Stef van der Merwe



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 14 February 2017 06:03 PM
To: 'Leyne, Sean' Sean@... [firebird-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 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.

LSSBcfs> I disagree!

LSSBcfs> There are times when I would love to be able to pivot data
LSSBcfs> on the server, to further process the data an SP.

LSSBcfs> Also, performing the pivot on the server could reduce the
LSSBcfs> total amount of data transferred to the client.

LSSBcfs> Sean





[Non-text portions of this message have been removed]