Thanks Mark
Agreed the PIVOT feature is wonderful. However I am stuck with the customer using Firebird(no complaints). But I still need a solution as to how go ahead? Please any suggestions or guidance, seeing as you have done this already? Stef van der Merwe From: [email protected] [mailto:[email protected]] Sent: 15 February 2017 11:53 AM To: [email protected] Subject: Re: [firebird-support] FIREBIRD PIVOT function or Matrix 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
