在SQL Server中使用pivot运算符无法获得所需的结果

Question

我试图透视一个两列表，但没有得到我想要的结果。

以下是Employees表中的数据示例：

DataPoint  Populated
name       Ram
email      [e-mail]
age        23
name       Shyam
email      [e-mail]
age        28
name       John
email      [e-mail]
age        33
name       Bob
email      [e-mail]
age        41

这是我想要的：

name   email                age
Ram    [e-mail]        23
Shyam  [e-mail]    28
John   [e-mail]       33
Bob    [e-mail]      41

这是我的代码：

;WITH NeedToPivot AS(
SELECT *
FROM Employees)
SELECT *
FROM NeedToPivot
PIVOT(MAX(Populated) FOR DataPoint IN("name","email","age"))x

以下是它返回的内容：

name    email               age
Shyam   [e-mail]   28

Answer 1

根据Sean Lange的反馈，我在Employees表中添加了EmployeeId列。pivot操作符现在理解了我想要的分组，查询正返回我想要的内容。

员工表现在看起来是这样的：

EmployeeId    DataPoint  Populated
1              name       Ram
1              email      [e-mail]
1              age        23
2              name       Shyam
2              email      [e-mail]
2              age        28
3              name       John
3              email      [e-mail]
3              age        33
4              name       Bob
4              email      [e-mail]
4              age        41