select agent,max(id) 
into agent_id
from tracker group by agent

##</code><code>##

begin tran
set nocount on
update agent_id
set ID = ID + 1 where Name = 'abc'
select ID from agent_id where Name = 'abc'
commit tran