Thanks all
But this still does not answer my question as to db design and query? Regards Stef van der Merwe From: [email protected] [mailto:[email protected]] Sent: 14 February 2017 06:03 PM To: 'Leyne, Sean' [email protected] [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]
