如您所知，PIVOT语法如下：

FROM table_source
PIVOT ( 
 aggregate_function ( value_column )
 FOR pivot_column
 IN ( <column_list>)
) table_alias

我想知道的是有可能，我们通过一个查询的<column_list>到PIVOT？

在行动中，我想写

FOR DepartmentName IN (SELECT Name From Department))

代替

FOR DepartmentName IN ([Production], [Engineering], [Marketing]))