SQL Server PIVOT表 [英] SQL server PIVOT TABLE

问题描述

我想在此评论的枢轴访问期间使用Pivot，但是此查询如何正确用于sql server

Hi I want to use Pivot for the month this commented pivot is in access But how this query properly work for sql server

Select [IPS].[Date],[IPS].[KPI Name],[KPI].[Graph Display],[KPI].[SortOrder],[IPS].[Value KPI] As KPI 
 From [Internal_Performance] As IPS,
  Map_KPI_Master As KPI 
  Where [IPS].[KPI Name] = [KPI].[KPI Name]  And
    [KPI].[PerformanceTrendInternal]= 1 And 
    [IPS].[Calculation Period]='Month'  And
     [IPS].[Level1]='GlaxoSmithKline' And 
     [IPS].[Currency]='GBP' And [IPS].[Country]='France') As Data
      Where (KPI<>Null Or Not KPI is null) Group By 
      Data.[Graph Display],Data.[KPI Name],Data.[SortOrder] Order By Data.[SortOrder] 
      --Pivot Month([Data].[Date])

推荐答案

请参阅此链接

examples/> http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/ [ ^ ]

谢谢

Hi,

refer this link

examples/">http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/[^]

thank you

这篇关于SQL Server PIVOT表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！