select StationId,StationName,MeasureDate,
CAST(CAST(T.GWTW0101001 AS FLOAT) AS VARCHAR) as 'pH 值',CAST(CAST(T.GWTW0101003 AS FLOAT) AS VARCHAR) as '浊度',
CAST(CAST(T.GWTW0101009 AS FLOAT)AS VARCHAR) as '溶解氧',CAST(CAST(T.GWTW0101009 AS FLOAT)AS VARCHAR) as '水温',
CAST(CAST(T.GWTW0101014 AS FLOAT)AS VARCHAR) as '电导率',CAST(CAST(T.GWTW0101018 AS FLOAT)AS VARCHAR) as '化学需氧量',
CAST(CAST(T.GWTW0101019 AS FLOAT)AS VARCHAR) as '高锰酸盐指数',CAST(CAST(T.GWTW0121001 AS FLOAT)AS VARCHAR) as '总氮',
CAST(CAST(T.GWTW0121003 AS FLOAT)AS VARCHAR) as '氨氮',CAST(CAST(T.GWTW0121011 AS FLOAT)AS VARCHAR) as '总磷'
from (SELECT c.StationId,c.StationName,a.MeasureDate,B.OriginalValue,B.FactorCode
FROM GWW_DM_T_HourDataMain a, GWW_DM_T_HourData b,GWW_BM_T_Station c
where a.HourDataCode = b.HourDataCode
and a.SiteMN = c.StationId
AND a.MeasureDate> '2010-03-01 08:00:00.000' and a.MeasureDate< '2022-03-15 08:00:00.000'
) A
PIVOT(MAX(OriginalValue) FOR [FactorCode] IN([GWTW0101001],[GWTW0101003],[GWTW0101009],[GWTW0101010],[GWTW0101014],[GWTW0101018],[GWTW0101019],[GWTW0121001],[GWTW0121003],[GWTW0121011])) AS T
order by StationId, MeasureDate asc