SQL Server - are PIVOT and UNPIVOT supported?
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
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
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.