begin
begin tran
select * from z_SAL_PRICELISTENTRY --with(nolock)
update z_SAL_PRICELISTENTRY set Column1=7
waitfor delay '00:00:10:10'
commit tran
end
update z_SAL_PRICELISTENTRY set Column1=8
begin
begin tran
select * from z_SAL_PRICELISTENTRY --with(nolock)
update z_SAL_PRICELISTENTRY set Column1=7
waitfor delay '00:00:10:10'
commit tran
end
update z_SAL_PRICELISTENTRY set Column1=8