Hi,
how to skip lines while procedure executing by other user ?

example

create sp_test
as
--#1
delete from x where a = 1
--#2
delete from x where a = 2
--#3
delete from x where a = 3

--#4
select * from x

user A executing sp_test
if user B executing sp_test at the same time run sp_test but skip #1; #3

Thanks

Alex