how to skip lines while procedure executing by other user ?

[alex]

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

[Rawhide]

You'll need a table to track activity. When user A is executing it, log to the talbe that A is executing. Do the same for the others. Use conditional statements based on the data in the log table to determine which steps to run.