Nested Stored Procedure

[destinyml]

Hi

I have a stored procedure [CreateHandle] which will return a one record with a single cell. E.g.:

[Handle]
GDR5H


Now I am trying to call the stored procedure from within another procedure and grab the return value into a variable. So something like this (not the correct syntax):

DECLARE @Handle char(5)
SET @Handle = EXEC [dbo].[CreateHandle]

What is the correct syntax?

Thanks

 

[jbenson001]

Procedure 1

ALTER  PROCEDURE dbo.usp_test1
  @Handle varchar(5) OUTPUT
as

set @Handle = (your select statement )

Procedure 2:

alter PROCEDURE dbo.usp_test2 AS
declare @retchar varchar(5)
exec dbo.usp_test1 @retchar output
select @retint

Jim

 

[destinyml]

Thank you for yuor reply.... I figured out that a user-defined function was a better choise though.

 

[jbenson001]

ok, glad you got it working