Thread: Best solution for this to increase the speed of execution

I have three different stored procedures. In every stored procedure I am inserting data.

eg in Sp1, i am inserting data in Table1
Above thing is same for other two.

And for each Sp I am Passing different parameters. And three Sp get executed every time. So it is time consumable. What will be the best solution for this to increase the speed of execution?

Originally Posted by kawareapeksha

I have three different stored procedures. In every stored procedure I am inserting data.

eg in Sp1, i am inserting data in Table1
Above thing is same for other two.

And for each Sp I am Passing different parameters. And three Sp get executed every time. So it is time consumable. What will be the best solution for this to increase the speed of execution?

hi kawarea
i am really sorry but it was dificult to visualize the problem which you are facing
please post some more detail then probably it would be easier to visualize and reply ....

call these there procedures with in another procedure and pass all the parameters to the main procedure