I have a table that I want to build a "crosstab" query from. MSAccess has this ability using the "PIVOT" command, but I need a standard SQL way of doing it (I am using Interbase SQL Server).
The table has the following fields (Unique on RID_QID):
RID (Respondent ID)
QID (Question ID)
I want to realize a query that has the RID field as the row header, the QID as the column header and the answer as the cell data.
Obviously, the trick is that the columns are dynamic depending on what records are in the table.
Thanks in Advance,