T1.MinValue,t1.MinValueTime,t1.AvgValue,t1.time Group by t1.EquipmentID, t1.varid,t1.VarName,t1.maxValue,t1.MaxValueTime, Select EquipmentID,MaxValue,time,ROW_NUMBER()over(partition by EquipmentID,convert(varchar(10),time,120) order by time desc) rn Select *, ROW_NUMBER() OVER(PARTITION BY equipmentid ORDER BY Time) rn into #2ADDF2D467BB4FD9849F958C1F16B8A3įrom (select * from RecordDatas201610 where time>=' 08:00:00' and and and and and and timet2.time where t2.maxValue>0 and t1.maxValue>0 group by t1.EquipmentID,t1.maxValue,t1.time Select * from sys.dm_os_performance_counters 注意:先建表结构,然后 insert into #RecordDatas exec('select * from tab')Ĭreate procedure.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |