On 14-2-2017 15:48, Dimitry Sibiryakov [email protected] [firebird-support] wrote: > 14.02.2017 14:15, 'Stef' [email protected] [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.
Having used SQL Server PIVOT and having done a similar thing manually, I have to strongly disagree with that. PIVOT is a strong feature and greatly simplifies producing a crosstab, especially if you want to do additional processing in a query with the result of that crosstab. Mark -- Mark Rotteveel
