Active Query Builder support area

SQL Server - are PIVOT and UNPIVOT supported?

Avatar
  • updated
  • Completed
Hi,

I receive the following error when attempting to parse T-SQL statements containing an UNPVIOT command:

Error connecting to Data Source: Invalid SELECT statement, unexpected token UNPIVOT.

Does this mean that AQB does not support the T-SQL PVIOT and UNPIVOT commands?

Thanks

Avatar
Kelly

Checking again on support of PIVOT/UNPIVOT function support.

Avatar
Kelly

Looking forward to support of this as well.

Avatar
Kobus Smit

Any update on this? We need support for PIVOT/UNPIVOT in an Oracle query.

Avatar
Andrey Zavyalov, PM
Hi,

You right, the current version of Active Query Builder doesn't support PIVOT/UNPIVOT clauses. Hopefully we will add support of these clauses in one of the next versions.