Is it possible that we pass a query to PIVOT as column list in SQL Server?
pivot, sql, sql-server, t-sql
Solution
The `IN` list defines the resultset layout.
It should be known at parse time.
Problem
As you know the `PIVOT` syntax is like below : ``` FROM table_source PIVOT ( aggregate_function ( value_column ) FOR pivot_column IN ( <column_list>) ) table_alias ``` I want to know is it possible that we pass a query as `<column_list>` to `PIVOT`? In action, I want to write `FOR DepartmentName IN (SELECT Name From Department))` instead of `FOR DepartmentName IN ([Production], [Engineering], [Marketing]))`