Passing variables between sp's | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Passing variables between sp’s

So I’m doing a select in one stored procedure and trying to pass a parameter from the one into the other. CREATE PROCEDURE usp_select_for_class_code
@numberList int output
AS SELECT @numberList = waco_dir_class
FROM agcwa_membership
execute usp_classCode But I keep getting told that Procedure ‘usp_select_for_class_code’ expects parameter ‘@numberList’, which was not supplied. Any help please
From the code its correct the execution would be ‘Exec usp_select_for_class_code 20’. Refer to books online about stored procedures for information. HTH Satya SKJ