测量点日冻结

select * from dbo.DayLineLose

exec ListStructure 'DayLineLose'

select m_id,Meter_ID,Stamp from vw_meter where Tran_ID=1
select m_id,Meter_ID,Stamp from vw_meter where Stamp>0

exec ListStructure 'GBTerminal.F10'

sp_helpconstraint 'GBTerminal.F10'
select * from tbZflx
select * from Trans_Area
0 分表
1 总表
2 分总表
3 出口总表

select * from DayData where F_date='2011-4-14' and RTU_ID=9001
select * from DayData where F_date='2011-4-13' and RTU_ID=9001

select SUM(day_z) from DayData where F_date='2011-4-14' and RTU_ID=9005
select SUM(day_z) from DayData where F_date='2011-4-13' and RTU_ID=9005
select (47890.47-47351.58) 676.80 538.89
select (47890.47-47351.58)/80      6.736125
select 80*8.46
select * from GBTerminal.F10
select * from TermData.CLDDayData

sp_helpconstraint 'TermData.CLDDayData'

insert TermData.CLDDayData(tid,cldh,FreezeDate,m_date,Pwr_time,ygz,wgz)
values(9001,2,'2011-4-14','2011-1-14 6:28','2011-4-13 19:59',100,null)

insert TermData.CLDDayData(tid,cldh,FreezeDate,m_date,Pwr_time,ygz,wgz)
values(9005,2,'2011-4-13',GETDATE(),'2011-4-13 23:51',1172,null)

delete TermData.CLDDayData where tid=9005 and FreezeDate='2011-04-13'

select * from  daydata where F_date='2011-4-15' and RTU_ID=9005
and M_ID=946

delete daydata where F_date='2011-4-15' and RTU_ID=9005 and M_ID=946

select a.tid,AreaCode,useid,cldh,stamp from GBTerminal.F10 a,GBTerminal.TerminalDec b where a.tid=b.tid

insert TermData.CLDDayData(tid,cldh,ygz,wgz,FreezeDate,pwr_time,m_date)
select a.tid,2,0,0,'2011-4-14 0:00:00','0001-1-1 1:01:10','2011-4-15 11:59:56'
from GBTerminal.F10 a,GBTerminal.TerminalDec b where cldh=2 and a.tid=b.Tid and AreaCode=1501 and useid=1214