> >UPDATE bin1 SET delay_int = >(select replace(replace(replace(CONVERT(VARCHAR(19), DATE, 120),'-',''),' ',''),':','')as int) >-(select max(replace(replace(replace(CONVERT(VARCHAR(19), DATE, 120),'-',''),' ',''),':',''))as int > FROM bin1 j1 > WHERE j1.date < bin1.date) >>