简单数据库处理
1.创建基础表(插入所有更新数据)
2.选择最后时间点数据,更新数据
update InformationCheck set
CheckInterval=b.CheckInterval
from(
select * from (
select row_number()over(partition by CheckId order by CreateTime desc ) nl ,* from (
select
CheckId
,CheckInterval
,CreateTime
from [InformationRegister] r
where convert(nvarchar(10),Createtime,112)='20150719'
--order by CheckId,CreateTime desc
) CheckR
where isnull(CheckResult,'')<>''
)Result
where Result.nl=1
)b