SQL行转列备忘

select * from (select  ROW_NUMBER() OVER(Order By [datetime] desc) as RowRank  ,[datetime],sum(case [sensorid] when 16 then transvalue else NUll end) c16,sum(case [sensorid] when 18 then transvalue else NUll end) c18 from SensorDatas where convert(varchar(10), [datetime], 120)='2011-11-10'  group by [datetime]  )  v where   v.RowRank>=0