将不同基站最后一条记录endtime为null的更改成endtime = getdate()
update hstnlinklog set endtime = getdate()
from
(select nodeid,max(begintime) as begintime from hstnlinklog where endtime is null group by nodeid) as t1 where hstnlinklog.begintime = t1.begintime and hstnlinklog.nodeid = t1.nodeid