HOW WE CALL STORED PROCEDURE IN ANOTHER PROCEDURE

ALTER PROCEDURE [dbo].[test]
@test1 nvarchar(10),
@somevalue bit

Declare @testid int

if (@somevalue = 0)
@testid = Exec InsertValue
@test1




Alter procedure InsertTest1
@test1 nvarchar(10)

Insert Into Test
(test)
values
(@test1)

RETURN SCOPE_IDENTITY()

Sorry

ALTER PROCEDURE [dbo].[test]
@test1 nvarchar(10),
@somevalue bit

Declare @testid int

if (@somevalue = 0)
@testid = Exec InsertValue
@test1




Alter procedure InsertValue
@test1 nvarchar(10)

Insert Into Test
(test)
values
(@test1)

RETURN SCOPE_IDENTITY()

The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points.

The Quomon Team

no i did not get appropriate answer
consider two procedure

one return like empid, name
and i want to supply empid in second procedure and second
procedure gives the result of first parameter which coming
from first procedure.
note: first procedure returns many rows
in result
we want result(of all records which passes from one procedure) from second procedure.