You could use a cursor to solve the problem:

declare @jobs table (street varchar(100),seq int)

insert into @jobs

select 'A',1 union all

select 'A',2 union all

select 'B',11 union all

select 'B',12 union all

select 'C',33...

Hi Cyberspy,

read this article: http://msdn.microsoft.com/en-us/library/ms175523%28v=SQL.100%29.aspx (Errors During Transaction Processing)

Hope this helps