Storedprocedures

Yes Shrikant

You can execute a storedprocedure into another storedprocedure.
This is one of the benifits of SP.
But you should know effect or result of inner SP because at the time of execution of outer SP you can't see output of inner SP.

 Create procedure SP1
 AS
 BEGIN

        exec SP2

 END

Try to use code of SP2 in the body SP1 (if you have and if it is not too much long) because it will save execution time.  


Thanks
Please click on "Accepted Answer" if it helps you 

Hi Shrikant.........
  yes... you can call like that.....

  for e.g:-
 
Create PROCEDURE [dbo].[testpravinnew]
 AS
BEGIN
SET NOCOUNT ON

  exec TestPravin param1,param2

END



Thanks,Mark it as "Accepted answer" if it helps you.
Pravin.

Dear sreekanth

you are partially correct, sp's can call
another sp but the levels is only upto 32.