I have a stored procedure with action flags passed to perform certain operations:

Code:
If @nvchrAction = "DO_THIS"
BEGIN

-- do stuff

END

If @nvchrAction = "DO_THAT"
BEGIN

-- do stuff

END

Now, from DO_THIS I want to repeatedly call DO_THAT. It's obviously the same stored procedure, just a different copy I am invoking.

My question is, does each call run in a separate thread? If I change a value in DO_THAT will the DO_THIS operation be affected by it?

Thanks!