calling sp inside sp

• syed.saad.tariq

  Newbie

  Points: 9

  More actions

  January 16, 2012 at 10:53 pm

  #253612

  I am calling different SPs inside a single sp, but i am having some problem when i am returning and getting id from sps

  here is my sp

  DECLARE @MemberID int

  DECLARE @GroupID int

  SET MemberID =EXEC dbo.spInsertMember @FBID,@FirstName,@LastName,@Email,@Mobile,@Nationality,@Country,@DOB,@Gender,@IsActive,@Modified,@Created

  SET @GroupID =EXEC dbo.spInsertGroup @Name,@GroupIsActive,@GroupModified,@GroupCreated

• padhis

  SSCommitted

  Points: 1762

  More actions

  January 16, 2012 at 11:02 pm

  #1434405

  Use Output Parameter in your Stored Procedure.

  http://msdn.microsoft.com/en-us/library/ms378108.aspx