call sp from another sp

how to call the following sp from another SP?

CREATE PROCEDURE general_select @tblname nvarchar(128),
@key varchar(10),
@debug bit = 0 AS
DECLARE @sql nvarchar(4000)
SET @sql = 'SELECT col1, col2, col3
FROM dbo.' + quotename(@tblname) + '
WHERE keycol = @key'
IF @debug = 1 PRINT @sql
EXEC sp_executesql @sql, N'@key varchar(10)', @key = @key

Help is much appreciated. thank you.

CREATE PROCEDURE usp_main
@param1 nvarchar(128),
@param2 varchar(10)
AS
EXEC general_select @tblname =@param1,@key =@param2

--Usage
EXEC usp_main @param1 ='TBL',@param2 ='BLABLA

'




"GW" wrote in message

> how to call the following sp from another SP?
>
> CREATE PROCEDURE general_select @tblname nvarchar(128),
> @key varchar(10),
> @debug bit = 0 AS
> DECLARE @sql nvarchar(4000)
> SET @sql = 'SELECT col1, col2, col3
> FROM dbo.' + quotename(@tblname) + '
> WHERE keycol = @key'
> IF @debug = 1 PRINT @sql
> EXEC sp_executesql @sql, N'@key varchar(10)', @key = @key
>
> Help is much appreciated. thank you.