SQL server PIVOT TABLE

See more:

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])