See How to return a value from dynamicaly executed T-SQL code FAQ #8130

>
>I have the following stored procedure:
>
>CREATE PROCEDURE ACC_usp_Next_Number @cTableName char(40),@cField AS CHAR(40),@iNext int OUTPUT AS
>
>DECLARE @cSQLString VARCHAR(256)
>
>SET @cSQLString = 'SELECT @iNext = MAX('+@cField+') FROM '+RTRIM(@cTableName)
>
>EXEC(@cSQLString)
>
>RETURN @iNext
>GO
>
>
>I get the error "Must declare the variable '@iTest'.". Basically I would like to get the next number of the table and field that I pass. Why is it telling me to declare @iTest if I'm passing it? Does anyone know of a better way to accomplish this?
>
>Thanks.