从列表中选择SQL PIVOT(在SELECT中) [英] SQL PIVOT SELECT FROM LIST (IN SELECT)

问题描述

是否可以执行PIVOT并从表中选择列表，而不是使用单个值?

Is it possible to do a PIVOT and select list from a table, instead of using single values?

类似这样(不正确的语法错误):

Like this (incorrect syntax error):

SELECT *
FROM (
    SELECT RepID, MilestoneID, ResultID FROM RM
) AS src
PIVOT (
    MAX(ResultID) FOR MilestoneID IN  (SELECT id FROM m) 
) AS pvt

这个可以编译，但是对我不起作用:

This one compiles, but doesn't work for me:

SELECT *
FROM (
    SELECT RepID, MilestoneID, ResultID FROM RM
) AS src
PIVOT (
    MAX(ResultID) FOR MilestoneID IN  ([1], [2], [3], [4]) 
) AS pvt

PS:我不想使用动态SQL，有没有一种方法可以不使用动态SQL?

PS: I do NOT want to use dynamic SQL, is there a way to do this without using dynamic SQL?

推荐答案

如果没有动态SQL，那么恐怕答案是否定的，那就无法完成.解析器需要预先知道值才能执行对列的数据透视.

If dynamic SQL is out then I'm afraid the answer is no, it can't be done. The parser needs to know the values up front to perform the pivot to columns.

这篇关于从列表中选择SQL PIVOT(在SELECT中)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！