Thank you for your response. I am now wondering about how much data you were passing into the stored procedure. You have opted to use temporary tables rather than...
I agree that if you have several different tasks to perform then it makes sense to write several different stored procedures, and in some cases some...