Hi!

If you consider the normalization rules you will end up with one "task assignment" table for each entity table you want to assign task to. In this scenario will not...

I agree to previous posts that you should break down the code to smaller procedures.

Another thing to think of is that you should avoid changing parameters inside your procedure,...