在SQLServer2008中：/**sql1：useSubqueryAS'PIVOT'ResultSet*/SELECT*FROM(SELECTa.Station_IDstationId,b.Factor_CodefactoryCode,a.ValuevalueFROMT_Data_RealaLEFTJOINT_Bas_FactorbONa.Factor_ID=b.Id)fPIVOT(max(f.value)forf.factoryCodein(ZD,COD,SW,PH))d/**sql2：usewith*/WITHAAS(SELECTa.Station_IDstationId,b.Fact