Subject | RE: [firebird-support] FIREBIRD PIVOT function or Matrix |
---|---|
Author | Stef |
Post date | 2017-02-15T11:46:05Z |
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: firebird-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 sd@...
[firebird-support] wrote:
> 14.02.2017 14:15, 'Stef' stef@... [firebird-support] wrote:Having used SQL Server PIVOT and having done a similar thing manually, I
>> 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.
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