Even i am searching for same. not getting. instead of update i need to delete from source table

try this

select count(id)

from tablename WITH(nolock)

where gpstime between A and B

and id=123;