询问枢轴关键字 [英] asking about pivot keyword

问题描述

TableA

--------

TableA
--------

EmployeeName        EffectiveDate        FieldType           FieldValue
------------        -------------        ---------           ----------
Mg Mg               1/1/2010              Title               Project Engineer
Mg Mg               1/1/2010              Department          IT Department
Mg Mg               1/1/2013              Title               Assist Project Manager
Hla Kyaw            1/1/2012              Title               Software Engineer
Hla Kyaw            1/1/2012              Department          IT Department

如何为TableA编写select语句以返回TableB共振峰...

如何使用pivot关键字.....帮帮我



TableB

------

How to write select statement for TableA to return in TableB formant...
how to use pivot keyword .....Help me

TableB
------

EffectiveDate       EmployeeName          Title                    Department
----------          ----------            -----                    -----------
1/1/2013            Mg Mg             Assist Project Manager       IT Department
1/1/2012            Hla Kyaw          Software Engineer            IT Department

推荐答案

查看示例代码：

Have a look at sample code:

SELECT EmployeeName, EffectiveDate, MAX(CASE WHEN FieldType = 'Title' THEN FieldValue END) AS Title, MAX(CASE WHEN FieldType = 'Department' THEN FieldValue END) AS 'Department'
FROM emptable
GROUP BY EmployeeName, EffectiveDate
ORDER BY EmployeeName

结果：

Result:

Hla Kyaw    2012-01-01 00:00:00.000 Software Engineer   IT Department
Mg Mg   2010-01-01 00:00:00.000 Project Engineer    IT Department
Mg Mg   2013-01-01 00:00:00.000 Assist Project Manager  NULL

可能您的样本数据不完整。您现在需要做的就是使用 MAX（） [ ^ ]函数 EffectiveDate field。

Probably your sample data are incomplete. All what you need to do now is to use MAX()[^] function on EffectiveDate field.

这篇关于询问枢轴关键字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！