如何在SQL 2008中使用Unpivot / Pivot [英] How To used Unpivot / Pivot IN SQL 2008

问题描述

Hello Guys，



我有一张包含以下数据的表格

Hello Guys,

I have one table which contain following data

   Date                 ID       RotaionId1    RotationId2    RotationId3

05/01/2014          1           A                       B                   C
05/02/2014          2           P                      Q                    R
05/03/2014          3           X                       Y                    Z 

我想输出像

I want output like

 Date                       ID      Rotation
05/01/2014             1           A
05/01/2014             1           B
05/01/2014             1           C
05/02/2014             2           P
05/02/2014             2           Q
05/02/2014             2           R

...



为此我尝试在sql中取消，但我无法获得此输出





任何人都可以建议我如何做这个



谢谢

Chean V.

...

for this i try unpivot in sql but i am unable to get this output


Can any one suggest me how to do this

Thanks
Chean V.

推荐答案

大家好我得到解决方案< br $> b $ b

解决方案是：

Hello guys i get the solution

Solution Is :

SELECT Date, TestId, Rotation
FROM
   (SELECT DATE, ID, ROTATION1, ROTATION2, ROTATION3
   FROM #Test) p
UNPIVOT
   (Rotation FOR TestId IN
      (ROTATION1, ROTATION2, ROTATION3)
)AS unpvt;

谢谢

Thanks

这篇关于如何在SQL 2008中使用Unpivot / Pivot的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！